Question

我使用低调指挥器,发现可运行的<条码>mysql。服务:

$ps -ef | grep mysqld
  501  4512     1   0 12:19 pm ??         0:00.06 /bin/sh /Applications/MAMP/Library/bin/mysqld_safe --port=8889 --socket=/Applications/MAMP/tmp/mysql/mysql.sock --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid --log-error=/Applications/MAMP/logs/mysql_error_log
  501  4849  4512   0 12:19 pm ??         0:00.29 /Applications/MAMP/Library/bin/mysqld --basedir=/Applications/MAMP/Library --datadir=/Applications/MAMP/db/mysql56 --plugin-dir=/Applications/MAMP/Library/lib/plugin --log-error=/Applications/MAMP/logs/mysql_error_log.err --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid --socket=/Applications/MAMP/tmp/mysql/mysql.sock --port=8889

但是,我忘记了这些口号,或者也许我没有提出过。

我怎么能写我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的口号?

以及<代码>mysqld_safe 服务运行意味着密码没有确定?

Answer 1

Stop the MySQL demon process using this command :
```
sudo /etc/init.d/mysql stop
```
Start the mysqld daemon process using the --skip-grant-tables option with this command:
```
sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &
```
Start the MySQL client process using this command:
```
mysql -u root
```
From the MySQL prompt execute this command to be able to change any password
```
FLUSH PRIVILEGES;
```

Then reset/update your password

SET PASSWORD FOR root@ localhost  = PASSWORD( password );

If you have a MySQL root account that can connect from everywhere, you should also do:
```
UPDATE mysql.user SET Password=PASSWORD( newpwd ) WHERE User= root ;
```

Alternate Method:

USE mysql
   UPDATE user SET Password = PASSWORD( newpwd )
   WHERE Host =  localhost  AND User =  root ;

And if you have a root account that can access from everywhere:
```
USE mysql
   UPDATE user SET Password = PASSWORD( newpwd )
   WHERE Host =  %  AND User =  root ;
```
For either method, once have received a message indicating a successful query (one or more rows affected), flush privileges:
```
FLUSH PRIVILEGES;
```
Then stop the mysqld process and relaunch it with the classical way:
```
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
```

友情链接