mysql user

对用户的理解

mysql 是以 username@hostname 作为整体的，两者一起相当于一个用户。

By the way, if you forget your root password of MySQL, just use add skip-grant-tables in /etc/my.cnf to login MySQL without password, and then add ‘root’@’localhost’ with all privileges with new password.

[root# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# for signing in without password by icesongqiang
# skip-grant-tables
#  then /etc/init.d/mysqld restart  ( service mysqld restart ) in cmd
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

login ,

> mysql
> grant all privileges on *.* to 'root'@'localhost' identified by 'rootpass';
>flush privileges;