[Solved]Very tricky MySql problem - Access denied
Posted: Fri Jul 09, 2004 4:59 am
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
As it is, the database is effectivley useless. I can view it, but change nothing.
Any help would be massivley appreciated - LinkJames