Welcome to LinuxQuestions.org, a friendly and active Linux Community. You are currently viewing LQ as a guest. Vlc media for mac. 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. Note that registered members see fewer ads, and ContentLink is completely disabled once you log in. Are you new to LinuxQuestions.org? Visit the following links:||| If you have any problems with the registration process or your account login, please. If you need to reset your password,. Having a problem logging in? This website uses cookies for analytics, personalisation and advertising. To learn more or change your cookie settings, please read our Cookie Policy.By continuing to browse, you agree to our use of cookies. Mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' I have been going at this for a couple hours now. Please visit to clear all LQ-related cookies. Introduction to Linux - A Hands on Guide This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter. For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own. To receive this Complete Guide absolutely free. Am having trouble with mysql i just installed fedora 5. Am able to log in to mysql by typing the password: mysql -p or mysql -u root -p. But if i try to log in without a password: # mysql or mysql -u root. I get an error message ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) i have run the cmd mysql> set password for 'root'@'localhost' = password ('new-password'); but still the error persists am trying to intall phpmyadmin which gets the same error therefore i have put on hold installing any apps that require a database till i sort this out. So i think m question is how do i enable mysql to let this cmd to work: mysql -u root. Any help will be gratly appreciated. You appear to be saying that you've set a password, and that mysql won't let you login without providing that password. That is how it is supposed to work. If you are saying that you have set the password to a blank string, then this is not the same as turning off the password checking. It's possible to set it up so that you don't need a password, but that is not advisable, particularly for the administrator. If you need to run a command that needs the password on the commandline then you can use --password= although this is less secure then entering it when prompted as the password will can be obtained by looking at the running processes. If you have set the password to be blank then use --password=' phpmyadmin does not need to know the password, depending upon the authtype you choose. The default on my install is cookie, which means that you need to login using the username and password from the phpmyadmin login page. It is really not a good idea to disable the password so I haven't given instructions on how to do it, but you can work it out from the mysql documentation. This are the main editing areas. $cfg['blowfish_secret'] = 'UHDWDHWUUI54656547igjglkk5677H' ->change this value to any random characters you want to use. Note you only need this if you are going to use the cookie auth_type. /* Servers configuration */ $cfg['Servers'][$i]['host'] = 'Localhost' $cfg['Servers'][$i]['extension'] = 'mysqli'; -> or mysql wichever you want to use $cfg['Servers'][$i]['port'] = 'your port'; ->leave blank for default $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['auth_type'] = 'cookie'; /* End of servers configuration */ Make sure your mysql is up and running first. Hi Guys, Issue:- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) [root@servert1 ~]# /etc/init.d/mysqld stop Stopping MySQL: [ OK ] [root@servert1 ~]# mysqld_safe --skip-grant-tables & [1] 13694 [root@servert1 ~]# Starting mysqld daemon with databases from /var/lib/mysql [root@servert1 ~]# mysql -u root Welcome to the MySQL monitor. Commands end with; or g.
0 Comments
Leave a Reply. |