D&C GLug - Home Page

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

Re: [LUG] Databases again

 

I remember I had trouble with the socket file on Mandriva 2005.

I was able to resolve it using the method here:
http://www.tech-recipes.com/mysql_tips762.html

on my installation my.cnf is in /etc/my.cnf

If you can't get that to work, what about downloading and installing the 
latest version (5.0) from the MySQL.com website:
http://dev.mysql.com/downloads/mysql/5.0.html

I use MySQL quite a bit with phpmyadmin and programming my own web pages and 
like how it all works. My code is probably horrible, but it seems to work for 
me - however, I don't really need to do anything exotic with the data, 
fortunately.

Hope this helps,

Mark Harvey

On Tuesday 20 Jun 2006 23:00, Paul Weaver wrote:
> 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