Several links to be noticed in the first installation of MySQL

1. Initialize Password

>sudo bin/mysqladmin-u root password ' pwd string '

2.ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no)

1) Add startup parameters: >mysqld_safe--user=mysql--skip-grant-tables--skip-networking &

2) Login:> mysql-u Root MySQL

3) Update password: >update user SET Password=password (' NewPassword ') where user= ' root ';

4) effective immediately:> FLUSH privileges;
3. Add Mysql.server Service

1) Copy the Mysql.server script to/ETC/INIT.D (initialize service, Mysql.server is the service name in Serivce Status-all)

>sudo CP Support-files/mysql.server/etc/init.d/mysql.server

>sudo service mysql.server status

2) let MySQL boot [defaults], cancel boot [remove]
>sudo update-rc.d-f mysql.server defaults [remove]

4. Add bin to environment variable >sudo export path= $PATH:/usr/local/mysql/bin (in the directory where Mysql/bin is located)

5, MySQL installation after the completion of the need to turn on the network login

use Mysql-u-P login After execute > Grant all privileges on * * to [email protected] '% ' identified by ' cipher text ' with Gran t option;