Shulou(Shulou.com)06/01 Report--

Example: users who create a library, such as for yii2basic library

Steps: Create library first; then create user

//create database drop schema if exists 'yii 2basic'; create schema if does not exist'yii2basic' default character set uft8mb4;use 'yii 2basic';//create user yii2 identified by 'yii2-passwd';grant all on yii 2basic.* to 'yii2'@'%' identified by 'yii2-passwd';//add remote access grant all on yii2basic.* to 'yii2'@'lcoalhost' identified by 'yii2-passwd';//add local access privileges flush privileges;//refresh privileges

Question

After creating the database according to the above steps, the local login test is normal, but using Navicat remote connection reports 10038 error?

Environment: Ubuntu 14.04/ mysql-server-5.6 / navicat client

Troubleshooting steps: 1. Check whether the server firewall is closed

2. Check whether mysql service is enabled in server

3. Check if port 3306 is occupied

4. View mysql my.conf related configuration

Related operations:

sudo ufw status Staus:inactive Not active

server mysql status mysql start/running,process id

ps -ef |grep mysql View mysql process

netstat -an |grep 3306 View port number

tcp 0 127.0.0.1:3306 0.0.0.0:* LISTEN

Check the bind-address configuration in my.conf, set it to 0.0.0.0

Thanks

See document: blog.csdn.net/u014520797/article/details/53412477

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.