LinuxQuestions.org
Review your favorite Linux distribution.
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 11-29-2005, 03:29 PM   #1
devfreak
Member
 
Registered: Mar 2004
Location: Maine
Distribution: gentoo 2004.1, ubuntu 4.10, FC3
Posts: 97

Rep: Reputation: 15
MySQL 4.1 user/password problem


I've been using MySQL 4.1 for more than a year at work, installed probably 10+ times on 3 different machines, both x86 and x86_64, and I've never really been able to set up a user with a password in phpMyAdmin or the console.

Whenever I try connecting with phpMyAdmin or ColdFusion odbc manager with that user and password I get denied.

I always set the host as %
I can't login at the console, either.

I can set up a user without a password and they are fine.

It has always been this way, with all different kinds of 4.1 for me. What's up with this?
 
Old 11-30-2005, 05:05 AM   #2
rylan76
Senior Member
 
Registered: Apr 2004
Location: Potchefstroom, South Africa
Distribution: Fedora 17 - 3.3.4-5.fc17.x86_64
Posts: 1,552

Rep: Reputation: 103Reputation: 103
Hi!

I did what you seem to want to do by doing this on MySQL 4.1.2 (note - this is a "standard" binary version, not one I compiled myself. Did you compile yours yourself? Might be part of the problem if you did):

1. Install according to BINARY_INSTALL.TXT (in MySQL distribution archive)
2. Start the server - execute

mysqld_safe --user=mysql &

in /usr/local/mysql/bin/

3. In the console, type

mysql -u root mysql

4. In MySQL, type

set password for root@localhost=password('my_root_password');

5. Then, create the "normal" user you want to use to access MySQL:

grant all privileges on *.* to normaluser@'%' identified by 'normaluser_password';
flush privileges;

This, at least on my setup, allows me to access mysql with the MySQL username

normaluser

and password

normaluser_password

from anywhere on my intranet.

Hope this helped! If it did not, you might want to post in the MySQL groups on the MySQL site, and list exactly how you install and setup MySQL relative to solving the problem.

Regards,
 
Old 11-30-2005, 11:19 AM   #3
devfreak
Member
 
Registered: Mar 2004
Location: Maine
Distribution: gentoo 2004.1, ubuntu 4.10, FC3
Posts: 97

Original Poster
Rep: Reputation: 15
Thanks a lot Stefan, I'll try that out!
 
Old 12-01-2005, 01:21 AM   #4
rylan76
Senior Member
 
Registered: Apr 2004
Location: Potchefstroom, South Africa
Distribution: Fedora 17 - 3.3.4-5.fc17.x86_64
Posts: 1,552

Rep: Reputation: 103Reputation: 103
Sure thing - this -should- work. I remember having a lot of problems with it myself as well, and re-installing quite a few times 'cause I couldn't get into my own MySQL server anymore...!
 
Old 03-23-2006, 01:54 PM   #5
devfreak
Member
 
Registered: Mar 2004
Location: Maine
Distribution: gentoo 2004.1, ubuntu 4.10, FC3
Posts: 97

Original Poster
Rep: Reputation: 15
The key is starting with --old-password because just about every thing I use only supports 3.x. I had to manually edit the /etc/init.d/mysql file, find where it starts mysql_safe and append --old-password, then I restarted mysql.

This is way out of date, my apologies for the bump, this is strictly for later reference.
 
  


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 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 Password Problem Flossie Linux - Software 6 04-09-2004 03:22 AM
setting user password to mysql!! baby_linu Programming 3 03-09-2004 10:59 AM
How do I add a host user password to mysql server? cmisip Linux - Networking 3 12-16-2002 09:57 AM

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

All times are GMT -5. The time now is 09:23 PM.

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