yum 安装mysql

yum list mysql*
yum -y install mysql-server
yum -y install mysql-devel
cp /usr/share/mysql/my-small.cnf /etc/my.cnf
vi /etc/my.cnf

[client]
port            = 3306
socket          = /var/lib/mysql/mysql.sock
default-character-set=utf8

[mysqld]
port            = 3306
datadir         =/var/lib/mysql
socket          = /var/lib/mysql/mysql.sock
default-character-set=utf8
interactive_timeout=28800000
wait_timeout=28800000

mysql -uroot
update mysql.user set password=PASSWORD('密码') where User='root';
flush privileges;

chown -R mysql:mysql /var/lib/mysql

mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak

 

myisamchk -f xmysql\*.MYI'