Linux - SoftwareThis 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
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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?
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.
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...!
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.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.