|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
|
|||
|
|||
|
I've installed MySQL v3.22.32 (binary)on my Suse 6.4 system. I followed the steps in the INSTALL file:
1. Unpak (Gunzip @ Tar) 2. Some change dir stuff 3. Scripts/mysql_install_db 4. bin/safe_mysqld & The MySQL server is now up and running (I checked it with a php3 file which can connect with the MySQL server (but gets a error message in return)(when I turn the MySQL server off the php3 file gives that he can't connect at all)). The PROBLEM is that I can't access the server. For example when I type: 'shell#mysql -u root test' I get the error message: Error 1045: Access denied for user: 'root@localhost' (using password:0) When a php3 file tries to connect to the Server (user=root) it gives the error message the user isn't alowed to. I started the Server with save_mysqld --skip-grant & and then everything works out fine. I can connect to the server and chance the database. I tried to add some users but that didn't work out. I read in a FQA that I should look for a file named 'user.ISD' but that file doesn't exists. The ./bin/mysqlaccess script doesn't work too. When I try to start it, it gives the error that the script doesn't exists. Who can help me out? Thanks in advance and greetings Wytse |
|
#2
|
|||
|
|||
|
it sounds like no users have been granted access on your server. did you set a root password? if so then you need to add the "-p" switch when connecting with "mysql -u root -p".
otherwise i would be inclined to check out the mysql documentation part 6 (access privelage system) and in particular part 6.13 (common causes of access denied) HTH marty |
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > Access denied MySQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|