D&C GLug - Home Page

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

Re: [LUG] Databases again

 

On Tue, Jun 20, 2006 at 08:05:37PM +0100, Neil Winchurst wrote:
> I found this
> /etc/rc.d/init.d/mysql start
> 
> I ran it, got the server running OK but still came up with the same
> error message as above when I tried to use the mysql program.

When you think it's running, type
# ps -ef|grep mysqld

You might/should have something like
root      4441     1  0 May29 ?        00:00:00 /bin/sh 
/usr/bin/mysqld_safe
mysql     4478  4441  0 May29 ?        00:04:40 /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

In my version/distro (debian), the socket is specified on the command
line

Is there anything in /var/run/mysqld? 

Alternatively you could use TCP/IP to connect to mysql
# mysql -u root -h localhost
OR (If you specified a root password during install, not sure if you
can)
# mysql -u root -h localhost -p

-- 
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