我一直在按照手册在Ubuntu上安装软件套件。我完全不了解MySQL。我已经在我的Ubuntu上完成了以下安装。
sudo apt-get update
sudo apt-get install mysql-server-5.5
sudo apt-get install mysql-client-5.5
sudo apt-get install mysql-common
sudo apt-get install glade
sudo apt-get install ntp
然后我做了
cd ~/Desktop/iPDC-v1.3.1/DBServer-1.1
mysql -uroot -proot <"Db.sql"
我最终得到以下错误消息。
错误1045(28000):拒绝访问用户'root'@'localhost'(使用密码:YES)
我该如何修复它并继续?
当前回答
从这个链接复制，我有同样的问题，这解决了问题。在我们为数据库添加密码之后，我们需要添加-p(基于密码的登录)，然后输入密码。否则，它将返回以下错误:
mysql -u root -p
其他回答
在终端输入:
mysql -u root -p
然后它会问你密码。
我尝试了Lahiru的正确答案，但它不能与macOS v10.14 (Mojave)上的MySQL服务器版本8.0.16 (Community)一起工作。
我遵循Sameer Choudhary的指示，并进行了一些调整，我能够更改根密码，并从本地主机启用根访问。
所有这些都不是必需的。如果您正在使用Homebrew在Mac OS上安装:
brew install mysql
请阅读官方文档:MySQL:如何重置Root密码
如果您可以访问终端:
MySQL 5.7.6及以上版本:
mysql
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
MySQL 5.7.5及以前版本:
mysql
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');
如果问题仍然存在，请尝试强制修改密码:
/etc/init.d/mysql stop
mysqld_safe --skip-grant-tables &
mysql -u root
设置新的MySQL root用户密码:
use mysql;
update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
flush privileges;
quit;
停止MySQL服务器:
/etc/init.d/mysql stop
启动MySQL服务器并测试它:
mysql -u root -p
当您的密码丢失时就会发生这种情况。
忘记密码时的修改步骤:
Stop MySQL Server (on Linux): sudo systemctl stop mysql Start the database without loading the grant tables or enabling networking: sudo mysqld_safe --skip-grant-tables --skip-networking & The ampersand at the end of this command will make this process run in the background, so you can continue to use your terminal and run mysql -u root (as root). It will not ask for a password. If you get error like as below: 2018-02-12T08:57:39.826071Z mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists. mysql -u root ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [1]+ Exit 1 Make MySQL service directory. sudo mkdir /var/run/mysqld Give MySQL user permission to write to the service directory. sudo chown mysql: /var/run/mysqld Run the same command in step 2 to run MySQL in background. Run mysql -u root. You will get the MySQL console without entering a password. Run these commands FLUSH PRIVILEGES; For MySQL 5.7.6 and newer ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password'; For MySQL 5.7.5 and older SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password'); If the ALTER USER command doesn't work use: UPDATE mysql.user SET authentication_string = PASSWORD('new_password') WHERE User = 'root' AND Host = 'localhost'; Now exit To stop the instance started manually: sudo kill `cat /var/run/mysqld/mysqld.pid` Restart MySQL sudo systemctl start mysql
