MySQL 和 PHPMyAdmin 问题:被锁定,无法重新登录

MySQL 和 PHPMyAdmin 问题:被锁定,无法重新登录

我正在尝试用mysql更改我的密码,但我并不是一个聪明人......

我一次又一次地在谷歌上搜索,并尽我所能解决这个问题。

我在用 Ubuntu 16.04,希望这有帮助。

我输入命令:

$ mysqladmin -u root password newpass

我得到:

mysqladmin: connect to server at 'localhost' failed error: 
'Can't connect to local MySQL server through socket /var/run/mysqld/mysqld.sock' (2)' 
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

有什么建议么?

另外,我最近按照一些指示将密码添加到 phpmyadmin 中这一页

这就是导致我遇到我正在尝试解决的问题的原因,如果这有道理的话。

任何帮助将不胜感激。

编辑:

sudo service start mysql

制作:

start: unrecognized service

尝试了这个:

 service mysql start

然后它启动了。然后使用以下命令测试状态:

service mysql status

制作:

● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
Active: active (exited) since Fri 2017-01-06 12:17:04 CST; 2h 38min ago
Docs: man:systemd-sysv-generator(8)

编辑2:

 sudo service mysql stop && sudo service mysql start && sudo service     mysql status
 [sudo] password for logan: 
 ● mysql.service - LSB: Start and stop the mysql database server      daemon
 Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
 Active: active (exited) since Mon 2017-01-09 09:11:39 CST; 16ms ago
 Docs: man:systemd-sysv-generator(8)
 Process: 6014 ExecStop=/etc/init.d/mysql stop (code=exited,      status=0/SUCCESS)
 Process: 6050 ExecStart=/etc/init.d/mysql start (code=exited,     status=0/SUCCESS

 Jan 09 09:11:39 logan-Latitude-E6320 systemd[1]: Starting LSB: Start and stop th
 Jan 09 09:11:39 logan-Latitude-E6320 systemd[1]: Started LSB: Start and stop the

编辑3:

我尝试了另一种方法,希望这些信息有用......

logan@logan-Latitude-E6320:~$ ps -ef | grep mysql
logan     8096  7119  0 13:21 pts/1    00:00:00 grep --color=auto mysql
root     19832  1244  0 Jan06 ?        00:00:00 /bin/sh     /opt/lampp/bin/mysqld_safe --datadir=/opt/lampp/var/mysql --pid-    file=/opt/lampp/var/mysql/logan-Latitude-E6320.pid
mysql    19975 19832  0 Jan06 ?        00:00:10 /opt/lampp/sbin/mysqld     --basedir=/opt/lampp --datadir=/opt/lampp/var/mysql --plugin-    dir=/opt/lampp/lib/mysql/plugin/ --user=mysql --log-     error=/opt/lampp/var/mysql/logan-Latitude-E6320.err --pid-     file=/opt/lampp/var/mysql/logan-Latitude-E6320.pid --    socket=/opt/lampp/var/mysql/mysql.sock --port=3306

相关内容