Solution
Step 1.)
Rem out the line in /etc/my.conf that was setting basedir to /var/lib. As seen below:
user=mysql
#basedir=/var/lib
Step 2.)
Create the directory "/var/run/mysqld" if it does not exist. Then chown that directory to mysql.mysql as below...
mkdir /var/run/mysqld
chown mysql.mysql /var/run/mysqld
Step 3.)
Start the service..
service mysql start
36 comments:
Thanx dear .....
thank you very much, this is very helpful for me, you are vey kind!
this worked fine and fixed my problem, the only issue I found was that on my system it wasn't called my.conf it was called my.cnf. Centos5 (red hat 5 enterprise)
thanks man... simple but powerful.
Thank you so much for this. It saved me lots of time. You RIP!
Thank you so much!
If I remove the basedir then it works for me too. But what if I want to change the database location....wouldn't I need the basedir in my.cnf
Very special thanks!!! It works now.
Thank you !!!!
God bless you. Worked like a charm.
May Peace and happiness reward you for the help provided here.
Superb solutions :P luckyly i ask Mr. Google and found this solutions here
Thanks... Saved my upgrades! :)
I also had to create user mysql
And chown from 27:27 to mysql:mysql on /var/lib/mysql.
I think by default my RedHat ES 5 does not have user mysql and the rpm's downloaded from mysql.com for that OS depended on that user existing prior to upgrade.
Now, i have this... Could anybody help me?
Starting MySQL/etc/init.d/mysql: line 159: kill: (6459) - No such process
great post!
Thanks
Its great the issue is being fixed
brilliant
Many thanx for this solution, after 3 hours working with the server, I googled to this superb solution
Thanks a lot!
:)
works fine! :)
Thank You ;)
Does NOT work with me.
I got this error message when start mysql: "Starting MySQL.... ERROR! Manager of pid-file quit without updating file."
Thanks!!!!!!!
it's people like you who make my day...thanks.
hi dud.. I try but its not working. still same.I did the following jobs..Create file on /etc named my.cnf and its had the values
[mysqld]
basedir=/var/lib/mysql
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
#basedir=/var/lib
[client]
socket=/var/lib/mysql/mysql.sock
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
-------
Then follow your instruction but not working.
I install
MySQL-client-standard-5.0.27-0.rhel4.i386.rpm
MySQL-devel-standard-5.0.27-0.rhel4.i386.rpm
MySQL-server-standard-5.0.27-0.rhel4.i386.rpm
Thanks a lot ,,thats really kool and easy to follow..
Atul
service mysql stop => Error.
MySQL manager or server PID file could not be found! [FAILED]
[root@web ~]# vi /etc/my.cnf
[root@web ~]# mkdir /var/run/mysqld
[root@web ~]# chown mysql.mysql /var/run/mysqld
[root@web ~]# service mysql start
Starting MySQL..............................................................................................
.... Then It cannot start.
You need to check this:
#df -h
It seems you haven't got free disk space in the /var partition.
Thanks =)
MySQL Workbench enables a DBA, developer, or data architect to visually design, generate, and manage all types of databases including Web, OLTP, and data warehouse databases. It includes everything a data modeler needs for creating complex ER models, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort. MySQL Workbench is available on Windows, Linux and Mac OS.
you have a nice post. thanks for sharing this enormous resources. keep it up.
I installed them with --nodeps option. After the server standard file installation, the
server is trying to start, but it fails giving this error -
Starting MySQLCouldn't find MySQL manager or server
Recently I just came across a good article on " Windows Server"
Here is its link.
please do ,
vi /etc/my.cnf
search for server-id
default is set to 1,
please change it to 2 and restart..
server-id = 2
service mysql restart
Thanks,
Girish Mahajan
service mysql stop
vi /etc/my.cnf
modify below entry to set value to 2.
server-id = 2
service mysql start
--Girish Mahajan
Thanks!
Exactly what I was looking for.
I had the same problem. The real problem is that my hard disk was almost full. I deleted a few large files and MySQL was back running.
Post a Comment