★ wanayoo — archive 1999 http://www.devshed.com/Talk/Forums/Forum4/HTML/000811.htmlNouvelle recherche | Portail wanayoo
DevShed Menu
* DevShed Home
* Developer News
* DevShed Brain Dump




UBBFriend: Email This Page to Someone!
  DevShed Discussion Forums
  MySQL
  Access denied MySQL

Post New Topic  Post A Reply
profile | register | preferences | faq | search

next newest topic | next oldest topic
Author Topic:   Access denied MySQL
WJM
Junior Member
posted August 06, 2000 07:48 PM     Click Here to See the Profile for WJM   Click Here to Email WJM     Edit/Delete Message Reply w/Quote
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

supine
Member
posted August 07, 2000 08:40 PM     Click Here to See the Profile for supine   Click Here to Email supine     Edit/Delete Message Reply w/Quote
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

All times are MST (US)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | DevShed.com

Copyright © 1997-2000 ngenuity. All rights reserved.

Powered by: Ultimate Bulletin Board, Version 5.41a
© Infopop Corporation (formerly Madrona Park, Inc.), 1998 - 1999.