#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Posts
    2
    Rep Power
    0
    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. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    35
    Rep Power
    15
    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

Similar Threads

  1. MySQL Error Access denied for user error
    By krishna_seshayy in forum MySQL Help
    Replies: 0
    Last Post: February 12th, 2004, 12:06 AM
  2. Replies: 0
    Last Post: January 30th, 2004, 09:46 PM
  3. database type: mySQL, MS SQL and Access
    By vinyl in forum ColdFusion Development
    Replies: 5
    Last Post: January 27th, 2004, 08:25 PM
  4. Replies: 5
    Last Post: January 20th, 2004, 11:33 PM
  5. access denied for user(simple problom)
    By shaba_dil in forum MySQL Help
    Replies: 3
    Last Post: January 7th, 2004, 10:11 PM

IMN logo majestic logo threadwatch logo seochat tools logo