CentOS安装MySQL

System Version：CentOS release 6.7（Final）

 

 1、下载MySQL

http://www.mysql.com/downloads/

当前下载版本：

MySQL-client-5.6.29-1.el6.x86_64.rpm

MySQL-server-5.6.29-1.el6.x86_64.rpm

 

2、安装MySQL

#rpm -i MySQL-server-5.6.29-1.el6.x86_64.rpm

#rpm -i MySQL-client-5.6.29-1.el6.x86_64.rpm

 

3、启动MySQL

service mysql start/stop/restart

 

4、登录MySQL

临时密码：#cat $HOME/.mysql_secrect

登录：#mysql -uroot -p$password

修改密码：set password for 'root'@'localhost'=password('pwd@123');

 

5、创建用户并赋权

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

GRANT ALL ON *.* TO 'username'@'%' with GRANT OPTION;

 

6、退出MySQL

quit

或

Ctrl -C --exit!

 

7、MySQL安装路径

/usr/bin: Client programs and scripts 

/usr/sbin: The mysqld server 

/var/lib/mysql: Log files, databases 

/usr/share/info: Manual in Info format 

/usr/share/man: Unix manual pages 

/usr/include/mysql: Include (header) files 

/usr/lib/mysql: Libraries 

/usr/share/mysql: Miscellaneous support files, including error messages,character set files, sample configuration files, SQL fordatabase installation 

/usr/share/sql-bench: Benchmarks 

/usr/my.cnf: config file 

 

8、启动MySQL失败

查看日志cat /var/log/mysqld.log

 进入/usr/bin目录，执行mysql_install_db，重新启动mysql成功

 

9、更新

flush privileges;