D&C GLug - Home Page

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

Re: [LUG] Databases again

 

On Wed, 21 Jun 2006 00:04:03 +0100
Mark Harvey <mark@xxxxxxxxxxxxxxxxxx> wrote:

> 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
> 
This is probably part of my problem, there is no my.cnf file anywhere
on my computer, so nothing to tell mysql about where to set up a socket
file.

> 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 will think about that.

Neil Winchurst

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

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