Have you run mysql_install_db? Does the mysql user have full permissions (read, write, execute) on the mysql data directory you created with mysql_install_db?

- Gabriel

On Dec 20, 2003, at 9:00 AM, Jon Pearse wrote:

... you can tell that this isn't going my way at all ...

I've got mysqld running. So, I go into the mysql shell and start setting things up again, which is when I start getting some interesting problems.
Firstly, 'SHOW DATABASES' doesn't work -


----------
mysql> SHOW DATABASES;
ERROR:
No query specified
----------

The same thing happens for 'SHOW TABLES' when you have selected a database - this is for the 'root' user.

Secondly, if I try and connect to the server from a PHP script, it looks in /Private/tmp for mysql.sock, rather than /tmp.

This was all going so nicely until a couple of weeks ago... now I have a contract looming over my head, it all goes to pot.

-Jon

-----------------------------------------------------------------------
 http://www.jonpearse.net                            [EMAIL PROTECTED]

 Some people come into our lives and quickly go. Some stay for a while
 and leave footprints on our hearts. And we are never, ever the same.
-----------------------------------------------------------------------


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to