Here are the steps to follow to fix it on Mac OS X 10.10.5 and MySQL v.5.7.10. Stop mysqld: The easiest way to stop mysqld is via MySQL in “System Preferences”. Just open it, look for MySQL and hit “Stop MySQL Server” button.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Posted by: Daniel Ho. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Daniel Ho. July 12, 2005 01:16PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO). Jamie Stephens.
If you didn’t install this utility, you need to go with launchctl tool.
Hi, I want to download sql in my linux system. root@localhost mydb# rpm -ivh MySQL-server-5.0.24a-0.glibc23.i386.rpm MySQL-cl ient-5.0.24a-0.glibc23.i386.rpm Preparing. ########################################### 100% package MySQL-client-5.0.24a-0.glibc23 is already installed package MySQL-server-5.0.24a-0.glibc23 is already installed root@localhost mydb# ls MySQL-client-5.0.24a-0.glibc23.i386.rpm MySQL-server-5.0.24a-0.glibc23.i386.rpm root@localhost mydb# rpm -q MySQL-server MySQL-client MySQL-server-5.0.24a-0.glibc23 MySQL-client-5.0.24a-0.glibc23 root@localhost mydb# wget -output-document=pubkeymysql.asc. Veridis.com:11371/export?id=-139043339 -09:39:42- =`pubkeymysql.asc' Resolving keyserver.veridis.com. Failed: Host not found.
![]()
root@localhost mydb# gpg -keyserver keyserver.veridis.com -recv-key 5072e1f5 gpg: can't get key from keyserver: Resource temporarily unavailable gpg: Total number processed: 0 root@localhost mydb# gpg -export -a 5072e1f5 pubkeymysql.asc root@localhost mydb# rpm -import pubkeymysql.asc root@localhost mydb# mysqladmin -u root password 'sait123' mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' please help me to download sql. Wrote: I want to download sql in my linux system. Unless you absolutely need some specific version that can't be found from the package system of your Linux distribution, for that question, you get best help from the support forums of your Linux distribution. For example on Ubuntu, installing MySQL requires this: sudo apt-get update sudo apt-get install mysql-server You can of course do that from GUI also, by searching the mysql server package and marking it for installation. For other distributions, there should be as simple methods for them too.
root@localhost mydb# mysqladmin -u root password 'sait123' Try this and it should ask you for the password: mysqladmin -u root -p It is not recommended to enter the password directly to the commandline, as it is visible to other users. Aggro wrote: wrote: I want to download sql in my linux system. Unless you absolutely need some specific version that can't be found from the package system of your Linux distribution, for that question, you get best help from the support forums of your Linux distribution. For example on Ubuntu, installing MySQL requires this: sudo apt-get update sudo apt-get install mysql-server You can of course do that from GUI also, by searching the mysql server package and marking it for installation. For other distributions, there should be as simple methods for them too. root@localhost mydb# mysqladmin -u root password 'sait123' Try this and it should ask you for the password: mysqladmin -u root -p It is not recommended to enter the password directly to the commandline, as it is visible to other users.
Hi, i tried your command. The result is seem's like below. root@localhost mydb# mysqladmin -u root -p mysqladmin Ver 8.41 Distrib 5.0.24a, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Administration program for the mysqld daemon. Usage: mysqladmin OPTIONS command command.c, -count=# Number of iterations to make. This works with -i (-sleep) only.#, -debug=name Output debug log.
Often this is 'd:t:o,filename'.f, -force Don't ask for confirmation on drop database; with multiple commands, continue even if an error occurs.C, -compress Use compression in server/client protocol.character-sets-dir=name Directory where character sets are.default-character-set=name Set the default character set.?, -help Display this help and exit.h, -host=name Connect to host.p, -password=name Password to use when connecting to server. If password is not given it's asked from the tty. I had following commands also. I got error root@localhost mydb# mysql -uroot -psait123 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) root@localhost mydb# mysqladmin -u root password 'sait123' mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' tankyou -raju.
![]()
Gordon Burditt wrote: root@localhost mydb# mysqladmin -u root password 'sait123' mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' Does root.ALREADY. have a password?
If so, use it (the old one). I dont Know what is that problem. I am able to enter in super user by using password.
Your command line above does not include the old root password. And from the error message, that's probably why it didn't work. Ok leave my old password.
How can i enter by using password in mysql. I tried to create new password but it give the same problem. I.e, Acess denied for user root.
How can i enter in mysql and use mysql.
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |