Linux - NewbieThis Linux forum is for members that are new to Linux.
Just starting out and have a question?
If it is not in the man pages or the how-to's this is the place!
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.
In stalled LAMP using the directions described here. It worked great. Unfortunately I then followed the security advice outlined here. After following this advice
Quote:
mysql> DELETE FROM user WHERE NOT (host = "localhost" AND user = "ReallyLongLongName");
mysql> FLUSH PRIVILEGES;
mysql is now unusable. It could well be that I chose too long a name for "mydbadmin". So when I try to log in I try to log in using
Code:
mysql -u ReallyLongLongName -p
I get
Quote:
ERROR 1045 (28000): Access denied for user 'ReallyLongLongNa'@'localhost' (using password: YES)
Maybe I can fix the problem by adjusting mysql to take longer names. Failing that I need to uninstall mysql so that I can reinstall it.
So when I try to log in I try to log in using
Code:
mysql -u ReallyLongLongName -p
I get
Quote:
ERROR 1045 (28000): Access denied for user 'ReallyLongLongNa'@'localhost' (using password: YES)
Are you prompted for a password and are sure you're using the correct password for the "ReallyLongLongName" user?
You can reset it if you want, be following the instructions here
Are you prompted for a password and are sure you're using the correct password for the "ReallyLongLongName" user?
You can reset it if you want, be following the instructions here
Regards
Yes. It is definitely the right password. My problem the root name for mysql is no longer "root" and I cannot use the new root name for some reason. That is why I want to completely uninstall mysql and reinstall it.
My problem the root name for mysql is no longer "root" and I cannot use the new root name for some reason. That is why I want to completely uninstall mysql and reinstall it.
You can uninstall mysql and start over if you like, but it's worth a try to reset the "ReallyLongLongName" user password. I guess this is the user you replaced mysql root with.
You can uninstall mysql and start over if you like, but it's worth a try to reset the "ReallyLongLongName" user password. I guess this is the user you replaced mysql root with.
Regards
I never had any problems remembering the password. I think the user name probably exceeded the table allocation for user names.
I decided to just back what I needed up and reinstall Ubuntu. I then went the through MySQL securing steps more carefully and everything seems to be fine now. If there is a way to just reinstall MySQL or LAMP, rather than reinstalling Ubuntu, that would be preferable should I encounter a similar problem in the future.
If there is a way to just reinstall MySQL or LAMP, rather than reinstalling Ubuntu, that would be preferable should I encounter a similar problem in the future.
No need to reinstall the whole OS for something like this. Use either synaptic or "apt-get remove" to remove the package(s) you want.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.