Apache Friends Support Forum

I installed the new XAMPP with the windows autoinstaller.
It worked fine... GREAT really. but now I cant connect to the database using mysqlcc from a different computer in the network.
I can connect if I am in the server but cant if I am on another workstation.
What I have to configure?
Thanx

Which user did you use to connect?

What's the exact error message?

I connect with local network IP 192.168.1.4 to the server so host is 192.168.1.4
using MYSQL control center (mysqlcc)
user "root"
no password
(then I created more users with and without password and failed also)

the error using user "root" without password is that I CAN connect but no database except test is shown when using a remote PC, but it works perfectly when running mysqlcc in the actual serer.

I have to mention that all my databases has as user "root" without password.

When I try to connect using anyother user it just wont connect saying mysqlcc.exe has generated an error and will be closed by windows... bla bla bla, windows error.

OK. In MySQL you have 2 users:
"root@localhost" --> privileges "ALL"
"Any@%" --> privileges "only connect"

So, if you connect from localhost with "root", all is correct. If you connect from another host with the user "root", you have the privileges from the user "Any".

If you go to http://localhost/phpmyadmin/, you can go to Priviliges (on the main screen) and review users, and add new ones.

Thanx a lot, the user had all the priviledges to NO database :p
It is working now and perfectly