mac下修改mysql－root密码－各种权限问题解决_MySQL

For example, if you run the server using the mysql login account, you should log in as mysql before using the instructions. Alternatively, you can log in as root, but in this case you must start mysqld with the --user=mysql option. If you start the server as root without using --user=mysql, the server may create root-owned files in the data directory, such as log files, and these may cause permission-related problems for future server startups.

shell> kill `cat /mysql-data-directory/host_name.pid`

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;

shell> mysqld_safe --init-file=/home/me/mysql-init &

UPDATE mysql.user SET Password=PASSWORD('MyNewPass')
    ->                   WHERE User='root';