1、我的MySQL安装在/usr/local/mysql/bin/mysql目录下,先为此目录取别名
$alias mysql=/usr/local/mysql/bin/mysql
2、进入MySQL命令
执行完第一步之后,执行:
$mysql -u root -p
终端会提示输入密码:
Enter password:
密码是这样来的。我们在安装MySQL的时候,会有这样一个对话框,如下图所示。图中画红线的地方,是我们软件为我们生成的临时密码。我们把这个临时密码输进去即可。
输入密码回车之后,若成功进入数据库,会显示下面的内容:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 121
Server version: 5.7.10
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
3、需改密码
此时我们已经进入了数据库,在MySQL命令下,输入下面的代码:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD(‘your new password’);
即可完成对密码的修改。