Re: Stuck Some More

In reply to Egor's request... Egor> > Ian, show me the contents of your .err file (the last 20-40 rows) This is the total contents of this file. /nfs/usr/libexec/mysqld: ready for connections /nfs/usr/libexec/mysqld: ready for connections /nfs/usr/libexec/mysqld: ready for connections /nfs/

Re: What next

In reply to Egor's question: > Execute: >ps ax | grep mysql > > Is there MySQL in the process list? Only mysqld (2 of them) 5404 p2- I 0:00.00 (mysqld) 15488 p4- I 0:00.00 (mysqld) Ian - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECT

Stuck Some More

Greetings Mysql has not been used on my server before, and I am the only user who has ssh access to the system, (any mysqld processes are mine) and have been trying to get mysql set up and working properly. Currenlty I have two mysqld processes idle on my system 5404 p2- I 0:00.00 (mysql

What next

I was able to start the mysql server using this suugested by Egor Egor > safe_mysqld& [1] 15476 user_obscured:/# Starting mysqld demon with databases from /usr/local/var nohup /nfs/usr/libexec/mysqld --basedir=/usr/local --datadir=/usr/local/var --port =30100 & but after this response, the ssh s

Stumped

Dear Group members Well I'm a bit stumped I've gone around a few times trying to get mysql working again on my server. Here is a current list of processes running - and it seems that mysqld is running (twice) - bother are idle (I). Is it safe to send a kill command to these processes? (and what

Re: New Setup

I now have two mysqld processes running on my server (Freebsd / apache), and no mysql (according to a ps command). What is the safe way to kill these two, and restart mysql? Ian - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April

New Setup

Using the commands you have offered... Egor> Your 'root' user doesn't have GRANT privilege ... Egor> Egor> You should change Grant_priv to 'Y' Egor> You can do this using UPDATE statement: Egor> UPDATE user SET Grant_priv='Y' WHERE user='root'; I get this response.. ERROR 1017: Can't

mysqld

I have run mysqld - and it tells me it is ready for connections - what syntax is it looking for? (is it the same as mysql ie commands and then a ';' to finish? Ian - Before posting, please check: http://www.mysql.com/manual.

Remove Mysql: New Setup

I seem to have done something that has crashed mysql on my server and I would really like to completely remove it and start again It's running on freebsd & is version 3.23.43 I think. Is there a safe procedure that will not crash my server? I can't seem to find any documentation on the msyql.or

New Setup

Egor> By default user 'root' has all privileges... Egor> Show me the output of following: Egor> SHOW GRANTS FOR 'root'@'localhost'; mysql> show grants for 'root'@'localhost' -> ; +--- --+ | Grants fo

Re: New Setup

gt; appears in these two records. > > > > I could not see any % mark in the user table - however I did find the % > mark > > in the mysql.host table - two records - one for localhost and the other my > > domain name, and the % mark was in the db column. > > >

Re: New Setup

e any % mark in the user table - however I did find the % mark in the mysql.host table - two records - one for localhost and the other my domain name, and the % mark was in the db column. Ian - Original Message - From: "Gelu" <[EMAIL PROTECTED]> To: "Ian Phillips"

New Setup

I thank anyone in advance who may be able to help me iron this out. 1. I am setting up mysql on my apache server. I have had it there for a while, but haven't really done much with getting my head round it. 2. I have figured out some shell commands, and have been able to set a root password. 3.