MySQL Forums
Forum List  »  Install & Repo

Trouble to allow users to connect to my MySQL Server
Posted by: Arthur Clerc
Date: March 01, 2015 05:47AM

I'm on Windows 7, and I use MySQL 5.6.

I followed several tutorials on internet to allow remote access to my MySQL server on my machine but none worked.

What I did :

- Installation of MySQL server
- Modifying my.cnf : binding the IP bind-address to my computer so not (127.0.0.1)
- Opening 3306 ports on my livebox
- Granting some privileges to users
Where I am :

My MySQL service doesn't want to start when I have a bind-address in my.cnf. It starts when bind-address is commented.

I get the following error :

2015-03-01 12:14:12 12216 [Note] Server hostname (bind-address): '...'; port: 3306
2015-03-01 12:14:12 12216 [Note] - '...' resolves to '...';
2015-03-01 12:14:12 12216 [Note] Server socket created on IP: '...'.
2015-03-01 12:14:12 12216 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2015-03-01 12:14:12 12216 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2015-03-01 12:14:12 12216 [ERROR] Aborting
When I'm trying to do a netstat, port 3306 is not used. When I change the port in my.cnf to another, I get the same error.

Thanks for your reply.

Arthur

Options: ReplyQuote


Subject
Written By
Posted
Trouble to allow users to connect to my MySQL Server
March 01, 2015 05:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.