Mysql connection from other computer to xampp server? Error 1045

Question

There is much information about this error but seems nothing works.

So I try to access to xampp mysql-server using the user root from local network.

mysql -uroot -p -h 192.168.100.48 --port=3306 (connecting from other local computer to xampp server)

But even I put right password (which I use for root) it not work. It works only if I log in using same computer where the server is running. I can use other user which I have specified but not root user. Why?

So how to fix this problem and getting it working?

score 0 · Accepted Answer · edited May 23 '17 at 11:59

0

Does the root user have the correct permissions?

Check the first duplicate link below for full answer - credit to Michael Berkowski:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.%'
    IDENTIFIED BY 'some_characters'  
    WITH GRANT OPTION;
FLUSH PRIVILEGES;

Have you tried search SO first? There are quite a few questions like this.

Possible duplicates:

How to grant remote access permissions to mysql server for user?

Remote MySql connection from other server

edited May 23 '17 at 11:59

Community

1
1

answered Mar 07 '16 at 10:33

Frank van Luijn

470
4
16

Yes. My bad. Seems there was another topic for this but didnt find right words for it. I got this working using those details. – icemanzzz Mar 07 '16 at 11:14
Glad to hear its working, if the answer helped you, could you accept it? – Frank van Luijn Mar 07 '16 at 12:38
Yeah. But how to accept it? I m quite new using this. – icemanzzz Mar 07 '16 at 13:36
Click the green check on the left of the answer ;) – Frank van Luijn Mar 07 '16 at 14:35

Mysql connection from other computer to xampp server? Error 1045

1 Answers1