You will need to do a grant all to the new user that you want to create. Also look at the 'mysql' database and tables. "USE mysql", "show tables;" then "select * from user;" and you can see what the protection settings are at.
You might need to delete the first record in the USER table. I'm using mysql with PHP and Apache and went through this same horror. -----Original Message----- From: Neil R Porter [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 23, 2001 16:15 To: Linux Newbie List Subject: [newbie] Apache, PHP and MySQL problem Hi All I've got LM8.1 up and running and I have np using apache as a test server on there along with php. However, MySQL is loaded (I chose it to be) but it doesn't work in the way I want it to. First off, I can create a database but only as root. Since I want to interogate/update etc using php on webpages served by apache then I need it to not require root. I've been to the MySQL site but can't seem to find out how to do it... Eek. Also, I've moved the default location for html files to my home directory so I can work on them on the fly on my workstation machine; don't know if this is an issue with this? Is there a MySQL conf file somewhere that I'm missing? I've trawled through the apache ones and they seem fine. Thanks for any help... I just hope there are some people out there who've had this requirement and got it going... Experienced help is what I need I think :( Ta Neil -- [EMAIL PROTECTED]
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
