无法使用MySQL Workbench访问Mariadb(Centos 7)
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了无法使用MySQL Workbench访问Mariadb(Centos 7),小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2645字,纯文字阅读大概需要4分钟。
内容图文
我在Centos 7上安装了Mariadb,我试图用MYSQL Workbench访问它.
我做了以下事情:
启动MariaDB执行以下命令:
systemctl start mariadb.service
自动启动MariaDB执行以下命令:
systemctl enable mariadb.service
启动MariaDB(仅执行一次)后,执行以下命令:
/usr/bin/mysql_secure_installation
运行时,我删除了匿名用户登录
我们还需要更改端口:
/etc/my.cnf.d/server.cnf
#Mariadb网络设置
[mysqld]
# comment out the bind address
#bind_address=127.0.0.1
现在我会收到一个错误
[root@localhost ~]# mysql -u root -p mcellblock -h 192.168.159.163 -P 3306
Enter password:
ERROR 1130 (HY000): Host '192.168.159.163' is not allowed to connect to this MariaDB server
然后我启用了连接权限:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'mcb'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
MariaDB [mcellblock]> select User, Host, password from mysql.user where Host <> 'localhost';
+------+-----------------------+-------------------------------------------+
| User | Host | password |
+------+-----------------------+-------------------------------------------+
| root | localhost.localdomain | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 |
| root | 127.0.0.1 | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 |
| root | ::1 | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 |
| root | % | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 |
| mcb | % | *A071D903A1ABA9752B05C16C573A095C80A7AFAD |
+------+-----------------------+-------------------------------------------+
5 rows in set (0.00 sec)
现在,当我尝试通过终端访问时,它可以工作:
$mysql -u mcb -p mcellblock -h 192.168.159.163 -P 3306
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 28
Server version: 5.5.47-MariaDB MariaDB Server
但是当我尝试通过MySQL Workbench访问时,我收到一个错误:
Please check
1) Check that mysql is running on server 192.168.159.163 ** IT IS
2) Check that mysql is running on port 3306 ** I can connect to it via the terminal so I assume it is
3) Check mcb has the rights to connect to 192.168.159.163 from your address ** It should as its setup for %
4) Make sure you are both providing a password if needed and using the correct password for 192.168.159.163 ** the passwords are the same
当我在本地安装MySQL Workbench时,它可以工作但不能远程工作.
有谁知道我错过了什么或如何解决这个问题?
解决方法:
事实证明这是centos机器上的防火墙问题.用telnet IP_ADDRESS 3306检查后,我无法通过我的其他VM或Windows访问.禁用防火墙后,它工作正常.
@Alex我以前也检查了端口,它正在正确收听.谢谢您的意见.
内容总结
以上是互联网集市为您收集整理的无法使用MySQL Workbench访问Mariadb(Centos 7)全部内容,希望文章能够帮你解决无法使用MySQL Workbench访问Mariadb(Centos 7)所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。