[Solved]Very tricky MySql problem - Access denied

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Linkjames
Forum Commoner
Posts: 90
Joined: Tue Sep 16, 2003 8:39 am

[Solved]Very tricky MySql problem - Access denied

Post 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
Last edited by Linkjames on Sun Aug 22, 2004 9:13 am, edited 1 time in total.
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Post by pickle »

What about the root account on the DB? That should have been set up when you install the server. Is it MySQL?
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
User avatar
Wayne
Forum Contributor
Posts: 339
Joined: Wed Jun 05, 2002 10:59 am

Post 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??
Linkjames
Forum Commoner
Posts: 90
Joined: Tue Sep 16, 2003 8:39 am

Post by Linkjames »

Its ok thanks lads. I have sorted it now. Reinstalled and was able to get in.
Post Reply