MySQL ERROR NUMBER 1045 问题

最新推荐文章于 2024-07-22 15:07:35 发布

转载最新推荐文章于 2024-07-22 15:07:35 发布 · 2.2k 阅读

文章标签：

#mysql #access #user #network #server #windows

本文介绍了解决MySQL远程访问权限被拒绝的问题方法。通过创建允许从特定IP地址访问的用户，可以解决从Windows机器访问Linux上MySQL服务器时出现的1045错误。文章详细说明了如何使用GRANT命令来配置远程访问权限。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

I will assume you have installed MySql on a Linux box. Then you have installed MySql Administrator on a Windows based machine, hence the 1045 Access denied Error.

I had the same problem and this is what i did.

Seems to me most of you haven't set the user up in mysql for access from that Windows machine. MySQL authenticates users based on Host and Username, not just username.

I don't know how your network or your server is set up so I would suggest the easiest way for you to set up this remote access is to create a user on the mysql server for remote access.

To do this log into your mysql server as root (or whatever your admin user is).
mysql -u root -p

Issue the statement....

GRANT ALL on *.* to 'new_user'@'192.168.22.10' IDENTIFIED BY 'new_user_password';

Replace dbname.tablename with the database and table names you need to access (USE *.* if you need access to all databases and tables)

Replace new_user with the chosen username.

Replace password with the chosen password.

If you want this user to be able to connect from any machine on your network replace 192.168.22.10 with 192.168.0.% or if you want to be able to connect from any location replace 192.168.0.34 with just a % but consider the security issues.