
MySql
数据库
糖冰橙
努力确实会上瘾
展开
-
mac启动MySQL报错:ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock
报错信息如下:~ mysql -u root -pERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)原因:MySQL未启动~ mysql.server startStarting MySQL. SUCCESS!启动后问题解决~ mysql -u root -pEnter password:Welcome to the MySQL mon.原创 2020-08-01 11:25:59 · 1413 阅读 · 0 评论 -
远程访问MySql
1. 首先保证电脑能被ping通2. 进入MySql,选中数据库:use mysql3. 查询表user中的用户:select host,user,password from user;4. 增加用户名为root,密码是123456,从任意IP都能访问数据库的用户:GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIE原创 2015-04-12 14:24:04 · 563 阅读 · 0 评论