1.安装mysql后初始化登陆密码
1.1 进入mysql配置目录
cd /etc/mysql/
1.2 打开配置文件 debian.cnf
sudo vim debian.cnf
里面的文件内容如下
---------------------------------
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = TA1el67hkuO04Nrn
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = TA1el67hkuO04Nrn
socket = /var/run/mysqld/mysqld.sock
---------------------------------
从上面的文档中得出用户(debian-sys-maint)和密码(TA1el67hkuO04Nrn)
1.3 从1.2中的信息,登陆mysql
mysql -u debian-sys-maint -pTA1el67hkuO04Nrn
1.4 选择mysql数据库
use mysql;
1.5 显示user表中的列
>show fields from user;
authentication_string这列就是密码
(注:以前的版本这个字段是password,如果是password下面的操作
将authentication_string替换成password即可)
1.6 修改密码
update mysql.user
set authentication_string=password('123456')
where user='root'
补充上述1.5的截图如下
2. 启动mysql的命令
service mysql start
3. 关闭mysql的命令
service mysql stop
4. 重启mysql的命令
service mysql restart