When I start MySql it just failed why?
mypc@computer:~$ sudo /etc/init.d/mysql restart
Stopping MySQL database server mysqld [ OK ]
Starting MySQL database server mysqld [fail]
Asked
Active
Viewed 3,185 times
0
Community
- 1
- 1
Amaresh Tiwari
- 947
- 13
- 36
-
2What does the error log say? – Jonathan Lam Oct 28 '15 at 05:00
-
1When I write this command (sudo /etc/init.d/mysql restart) and press enter button it will return * Stopping MySQL database server mysqld [OK] * Starting MySQL database server mysqld [fail] nothing else – Amaresh Tiwari Oct 28 '15 at 05:09
-
try `sudo vim /var/log/mysql.err` – Jonathan Lam Oct 28 '15 at 05:10
-
sudo: vim: command not found – Amaresh Tiwari Oct 28 '15 at 05:15
-
1Okay, then try `sudo gedit /var/log/mysql.err` – Jonathan Lam Oct 28 '15 at 05:15
-
And it will also return error on my magento home page SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) – Amaresh Tiwari Oct 28 '15 at 05:16
-
I just install the WordPress in my system and after that when I login MySql it will return (#2002 Cannot log in to the MySQL server) this message – Amaresh Tiwari Oct 28 '15 at 05:18
-
nothing it will display – Amaresh Tiwari Oct 28 '15 at 05:22
1 Answers
-1
I got this answer from this SO question
If you're getting the #2002 Cannot log in to the MySQL server error while logging in to phpmyadmin, try editing phpmyadmin/config.inc.php and change:
$cfg['Servers'][$i]['host'] = 'localhost';to:
$cfg['Servers'][$i]['host'] = '127.0.0.1';
Community
- 1
- 1
Amaresh Tiwari
- 947
- 13
- 36