Problem connecting to Mysql on Linux

[Anon]

I have installed RED HAT LINUX 7.0 as well as PHP and MYSQL

PHP CORE shows MYSQL support is enabled but every time I try to connect to MySQL database, the
following error happens:

Warning: MySQL Connection Failed: Cant connect to
local MySQL server through
socket/var/lib/mysql/mysql.sock` (111)

I would be grateful if any one help me to fix the prolem

[gushy]

have you started mysql? I would guess not as it can't find the socket to connect to it.

-- Nick Gushlow

[Anon]

Thanks for you response.

I guess you are right, probably I have not started mysql. Actually I am new to Linux and do not know how to start mysql. Could you please advise to what command I should use to start mysql serever?. Plesae explain with comprehensive details.

Regards

Misha

[gushy]

First let's see if it is running. at the command line type:
ps ax | grep mysql

if you see ouput like this it's running:
895 ? S 0:00 /bin/sh ./bin/safe_mysqld --datadir=/usr/local/mysql/
930 ? S 0:01 /usr/local/mysql/bin/mysqld --defaults-extra-file=/us
1048 ? S 0:01 /usr/local/mysql/bin/mysqld --defaults-extra-file=/us
1049 ? S 0:06 /usr/local/mysql/bin/mysqld --defaults-extra-file=/us
3864 pts/0 S 0:00 grep mysql

If you don't then you need to start it. I don't know where you've installed it, but if you find your mysql directory you will find in it a suub-directory called support-files. enter that directory and type:
mysql.server start

Done. Good luck.

-- Nick Gushlow

[gushy]

There are some good tutorials on getting mysql/apache/php running on www.devshed.com

That's how I learnt, check them out.

-- Nick Gushlow

[Anon]

“ps ax | prep mysql” generated the following information:

1128 pts/0 S 0:00 grep mysql

I installed mysql rpm, now it resides in /var/lib/mysql and /usr/share/mysql (clint probably)
I did not find any support files under those two directories.

[gushy]

Urgh MySQL RPM. I've never managed to figure that one out. I always use the binary tarball.

Your output shows that mysql definitely isn't running.

Change to the root user on your box and then do:

find / -name mysql.server

that should find the file for you.

when you find it change to the directory it is in and run it using:

./mysql.server start

As I've said I personally don't like the MySQL RPM , I'd uninstall it, download the binary tarball and then install it using guide in the README. Works every time for me.

-- Nick Gushlow

[Anon]

I did everything as you suggested and the output was as follows:

bash: ./mysql.server: Permission denied

[gushy]

OK you found it, thats a step in the right direction. What directory was it in?

When you ran './mysql.server start' who were you logged in as? You should be in as root, or the owner of the file.

Do an ls -la mysql.server in the directory to see the owner and the group. Then make sure you are logged in as the owner of the file (or root) and then try to run it.

-- Nick Gushlow

[Anon]

Dear Nick Gushlow,

Thank you very much.

Finally, I have succeeded in connecting to MySQL server.

Misha
E-mail: [e-mail]

[gushy]

Excellent news!! Well done Misha. You'll find that the hard work was worth it, once you've started using MySQL you'll never look back.

-- Nick Gushlow

[frogxin]

very nice to meet you!
I ran 'ls -la mysql.server',it output '-rw-r--r-- 1 root root 4023 Oct 22 17:03 mysql.server' .but I ran './mysql.server start',it still output 'bash: ./mysql.server: Permission denied',what's wrong with it? thanks

[gushy]

your mysql.server is not set to be executable. To fix this do:
chmod +x mysql.server

-- Nick Gushlow