D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] Databases again

 

Neil Winchurst wrote:
>> I tried, both as root and as normal user. It still comes back with the
>> error message about being unable to connect to the socket.
> 
>> [root@localhost neil]# /usr/share/mysql/mysql.server start &
>> Starting MySQL Server                                           [[1]

Wrong location in most cases. Best to start from /etc/init.d/

# /etc/init.d/mysql start

>> 6190 [root@localhost neil]#   OK  ]
>> [root@localhost neil]# ps aux | grep mysql

Looks to me like mysql isn't actually running.

$ ps aux | grep mysql
should produce:

33:root      2598  0.0  0.4   3480  1204 ?        S    11:31   0:00
/bin/sh /usr/bin/mysqld_safe
34:mysql     2659  0.0  1.4 129268  3728 ?        Sl   11:31   0:01
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306
--socket=/var/run/mysqld/mysqld.sock
35:root      2660  0.0  0.1   1788   492 ?        S    11:31   0:00
logger -p daemon.err -t mysqld_safe -i -t mysqld
90:neil      6212  0.0  0.3   3428   804 pts/0    R+   17:28   0:00 grep
-n mysql


-- 

Neil Williams
=============
http://www.data-freedom.org/
http://www.nosoftwarepatents.com/
http://www.linux.codehelp.co.uk/

Attachment: signature.asc
Description: OpenPGP digital signature

-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html