运行MySQL

cp support-files/mysql.server /etc/init.d/mysql

chkconfig mysql on

service mysql start

1. 编辑文件并添加内容。

   vim ~/.bash_profile

   添加的内容如下：

   export PATH=/usr/local/mysql/bin:$PATH

   添加环境变量后如图1所示。

   图1 添加环境变量
   
2. 使环境变量生效

   source ~/.bash_profile

需要输入的密码为配置MySQL时产生的初始密码，请留意初始密码包含了特殊字符。

ln -s /data/data/mysql.sock /tmp/mysql.sock

mysql -uroot -p

如果忘记初始密码，可参见问题三：忘记MySQL的初始密码设置密码并重新连接。

下述命令中的“mypassword”需要根据实际修改成要配置的密码。

SET PASSWORD = PASSWORD('mypassword');

UPDATE mysql.user SET authentication_string =PASSWORD('mypassword') WHERE User='mysql';

GRANT ALL PRIVILEGES ON *.* TO mysql@localhost IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO mysql@"%" IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

下述命令中的“mypassword”需要根据实际修改成要配置的密码。

mysql -uroot –pmypassword