Page 1 of 1

[Solved]Very tricky MySql problem - Access denied

Posted: Fri Jul 09, 2004 4:59 am
by Linkjames
I have created a database with 2 users for our intranet. The first user was to be used by my php scripts and the second was to be for admining, only on the local machine. The problem is that I listed the host as 'testweb' when in actual fact it is communicating with the mysql server as 'testweb.mycompanysname.com'. This means that I cannot log on to the admin account. IT have tryed removing the dns suffix (The mycompany.com bit) but they can't. I have tryed deleting the server and reinstalling, but it is retaining the users permissions.

As it is, the database is effectivley useless. I can view it, but change nothing.

Any help would be massivley appreciated - LinkJames

Posted: Fri Jul 09, 2004 9:44 am
by pickle
What about the root account on the DB? That should have been set up when you install the server. Is it MySQL?

Posted: Fri Jul 09, 2004 10:07 am
by Wayne
I have tryed deleting the server and reinstalling, but it is retaining the users permissions.
what exactly do you mean?
what entries have you put in the mysql.user tables for these users and when you try to connect do you connect on IP address or to LOCALHOST??

Posted: Fri Jul 09, 2004 11:25 am
by Linkjames
Its ok thanks lads. I have sorted it now. Reinstalled and was able to get in.