problem to start mysql

R

ra3ou1

New member
Joined
Feb 21, 2014
Messages
4
hi
my server it's worked good and dont have problem
but today i check site and see can't connect to db

check mysql and see it stoped

i'm try to start it but give me this error

# /etc/init.d/mysqld start
Starting MySQL... ERROR!

please help me to solved it
 
Best is to check your log what it says.
For example /var/lib/mysql/server.yourdomain.com.err
which is the mysql error logfile.
 
~]# /var/lib/mysql/sec.xxxxxx.com.err.err
-bash: /var/lib/mysql/sec.xxxxxx.com.err: Permission denied
 
# service mysqld status
ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists


i'm remove it

]# rm -rf /var/lock/subsys/mysql
[root@sec subsys]# service mysqld restart
ERROR! MySQL server PID file could not be found!
Starting MySQL... ERROR!
ERROR! Failed to restart server.
[root@sec subsys]# service mysqld start
Starting MySQL... ERROR!
[root@sec subsys]# service mysqld status
ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
[root@sec subsys]#
 
You have to look into that file. Like this for example:
Code: 
less /var/lib/mysql/sec.xxxxxx.com.err
you can quit by typing q or is that also giving a permission denied?
 
i have same error too. i cant downgrade and upgrade.
what can i do help pls
 
As Richard sayd twice, check the logs, report the error and you may have some help...

Without logs... is quite like look for something without know what we are looking for...
 
You must log in or register to reply here.
Back
Top