LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 04-09-2004, 02:20 AM   #1
Flossie
LQ Newbie
 
Registered: Sep 2003
Posts: 26

Rep: Reputation: 15
Mysql Password Problem


I'm trying to give my users who have access to my mysql database a password so that they require a password when connecting.

I've updated the password field in the table user in the mysql database using the password function to encrypt it but MYSQL doesn't seem to want to accept the password.

I'm using MYSQL-Front on a Windows 2000 Machine to connect to the MYSQL Server.

If I enter a password It cannot connect to the database but If I enter just a username I can connect without any problems.

Is there something I need to set to force MYSQL to accept Passwords.

Hope someone can help this is driving me round in circles

Thanks
Flossie
 
Old 04-09-2004, 02:30 AM   #2
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 271Reputation: 271Reputation: 271
Have you tried to simply connect as the root user thru the command line or the such and attempt to update mysql by adding a user that way with a password? It sounds to me like its a problem with whatever front end GUI your using.
 
Old 04-09-2004, 02:38 AM   #3
Flossie
LQ Newbie
 
Registered: Sep 2003
Posts: 26

Original Poster
Rep: Reputation: 15
Just a quick question.


After Changing the password do you need to do a Flush Priviliges before the password is activiated.
 
Old 04-09-2004, 03:11 AM   #4
BobNz
Member
 
Registered: May 2003
Location: NewZealand
Distribution: RH9.0
Posts: 74

Rep: Reputation: 15
Did MySQL/PHP come embedded or did you install? I think theres an issue using md5 encryption if MySQL/PHP came embedded. not sure on this maybe someone can shed some light?
 
Old 04-09-2004, 03:13 AM   #5
Flossie
LQ Newbie
 
Registered: Sep 2003
Posts: 26

Original Poster
Rep: Reputation: 15
No I downloaded MYSQL from www.mysql.com and installed it myself.
 
Old 04-09-2004, 03:19 AM   #6
BobNz
Member
 
Registered: May 2003
Location: NewZealand
Distribution: RH9.0
Posts: 74

Rep: Reputation: 15
For a user to connect from somewhere other than the localhost they have to be created as

mysql> GRANT "whatever privileges" ON *.* TO user@"%"
-> IDENTIFIED BY 'some_password' ;
mysql> FLUSH PRIVILEGES;

check out the manual, excellent document.

http://dev.mysql.com/doc/

Bob

Last edited by BobNz; 04-09-2004 at 03:23 AM.
 
Old 04-09-2004, 03:22 AM   #7
Flossie
LQ Newbie
 
Registered: Sep 2003
Posts: 26

Original Poster
Rep: Reputation: 15
I'll give that I try

Thanks for all your help. Don't know where I would be without these forums

Thanks again
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL 4.1 user/password problem devfreak Linux - Software 4 03-23-2006 01:54 PM
Mysql password problem (need to erase old) runlevel0 Programming 1 07-27-2005 01:22 PM
MYSQL password problem. osat3ch Linux - Software 2 08-20-2004 09:00 AM
mysql password problem varala_kanth Linux - Newbie 1 06-10-2004 03:19 AM
mysql - problem with start and password CharlesButters Linux - General 0 11-09-2001 03:15 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 01:21 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration