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
Last edited by Linkjames on Sun Aug 22, 2004 9:13 am, edited 1 time in total.
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??