MySQL Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesMySQL Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here!
  #1  
Old August 6th, 2000, 08:48 PM
WJM WJM is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2000
Posts: 2 WJM User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation 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

Reply With Quote
  #2  
Old August 7th, 2000, 09:40 PM
supine supine is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2000
Posts: 35 supine User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 9
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

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesMySQL Help > Access denied MySQL


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway