从其他机器连接到MySQL
问题描述:
我在我们的域上的Windows 2003服务器上安装了MySQL。我无法从域中的其他计算机连接到它。我打开MySQL管理员面板,并尝试将服务器名称从localhost更改为它不能识别的计算机名称。我已经尝试完全限定名称也。任何想法我需要改变?
I have MySQL installed on a Windows 2003 server on our domain. I cannot connect to it from other machines on the domain. I open up the MySQL Administrator panel and try to change the server name from localhost to the machine name it does not recognize it. I have tried fully qualifying the name also. Any ideas what I need to change?
答
我试图使用默认的root用户ID连接到数据库。我创建了一个新用户,并授予此用户对所需表的读取权限。
I was trying to connect to the database using the default root userid. I created a new user and gave this user read permission to the needed tables.