D&C GLug - Home Page

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

Re: [LUG] Databases again

 

On Tue, 20 Jun 2006 23:00:28 +0100
Paul Weaver <iso@xxxxxxxxxxxx> wrote:

> 
> 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
> 
I tried this but got nothing at all. I think part of the problem is
that I do not have an /etc/my.cnf file. In fact I do not have a my.cnf
file anywhere at all. So nothing is telling mysql what to do about a
socket file.
> 
> Is there anything in /var/run/mysqld? 
> 
No

> 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 mysql command doesn't work, so I can't run the above.

Neil Winchurst

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