Hi,

I have installed MYSQL server to my
machine and having problem when I try start
mysql haaving following problem would aanyone ccan help me. I am new to Mysql


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


Ananthan

Maybe try ./mysqld start or if on most linux dist. /etc/init.d/mysqld start

I have tried and giving ssome otehr
issues as follows

[root@localhost bin]# ./mysqld
Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
020531 14:48:01 Aborting

020531 14:48:01 ./mysqld: Shutdown Complete
[root@localhost bin]# ./mysqld
Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
020531 14:48:01 Aborting

020531 14:48:01 ./mysqld: Shutdown Complete


Dont reallly know where security fille or would you
plss direct me how to configure.

ananthan

With respect, since you are writing web applications, you should learn to use the web to answer questions.

The documentation is extensive and online:
http://www.mysql.com/doc/P/r/Privilege_system.html

and be sure to read

http://www.mysql.com/doc/G/e/General_security.html

The search tool in the docs is useful.

Or, when I'm stumped even by docs, I do a google search with a meaningful part of the error message that seems most relevant.

In the above case, use the query string:

"find out how to run mysqld as root"

Including the quotes... and the fourth result contains a link to...
http://list.cobalt.com/pipermail/cobalt-users/2001-March/036744.html

... which may help you.

Not trying to be rude here but I feel its best to teach someone to fish rather than to hand them the fish all the time. Learning how to search for answers is the number one improvement any technical person can make to their career prospects.

You'll rarely find that you are the first person in the world to have come across a particular issue, so finding answers is more about learning how to ask questions - or in this case, search via google.

find where safe_mysqld (the file) is

and run it:

./safe_mysqld --user=mysql &

like me, i have myysql installed to /usr/local/mysql

i have the mysql.server support-file i use to start and stop it

but in short, you could just do:

/usr/local/mysql/bin/safe_mysqld --user=mysql &