本文共 1540 字,大约阅读时间需要 5 分钟。
root密码:123456
sudo apt-get install mysql-server mysql-client
去官网下载mysql-5.6.28-linux-glibc2.5-x86_64.tar包,解压到/usr/local/mysql-5.6.28
groupadd mysqluseradd -r -g mysql mysqlchown -R mysql:mysql mysql-5.6.28
su mysqlcd mysql-5.6.28/scripts./mysql_install_db --user=mysql --basedir=/usr/local/mysql-5.6.28 --datadir=/usr/local/mysql-5.6.28/dataexit
cd /software/mysql-5.6.28/support-filescp my-default.cnf /etc/mysql/my.cnfcp mysql.server /etc/init.d/mysql
vim /etc/init.d/mysql 修改文件中的两个变更值, 若mysql的安装目录是/usr/local/mysql,则可省略此步
basedir=/usr/local/mysql-5.6.28datadir=/usr/local/mysql-5.6.28/data
vim /etc/profileexport MYSQL_HOME="/usr/local/mysql-5.6.28"export PATH="$PATH:$MYSQL_HOME/bin"保存退出. /etc/profile
chkconfig --add mysqlchkconfig mysql on
或者用rcconf配置
service mysql start
或者直接用/etc/init.d/mysql启动
mysqladmin -u root password '123456' #修改root用户密码mysql -u root -p #登录mysql,需要输入密码mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; #允许root用户远程访问mysql>FLUSH PRIVILEGES; #刷新权限mysql>exit
新版本MySQL改密码不用password字段,而是authentication_string字段
cd $MYSQL_HOME./bin/mysqld_safe --basedir=/usr/local/mysql-5.6.28 --datadir=/usr/local/mysql-5.6.28/data --skip-grant-tables &mysql -u root mysqlUPDATE user SET password=authentication_string("new_password") WHERE user='root';FLUSH PRIVILEGES;
确保数据目录权限设置为实际运行mysql 的用户权限
chown -R mysql:mysql /usr/local/mysql-5.6.28/data
转载地址:http://cxhrb.baihongyu.com/