libmysqlclient error

[Sutz]

mysql> GRANT ALL ON *.* TO root@%;
flush privileges;
quit
Query OK, 0 rows affected 

Query OK, 0 rows affected

 

hmm.. does this mean nothing changed :? nvm it did i checked the users

 

LC still cant connect grrrrrr

[CyberClaus]

XD well try it, cause that means nothing

[CyberClaus]

MaX, install the server on centos, and use your loopback, mysql will never reject a localhost connection

[Sutz]

didnt work!

 

I giveup lol will try install mysql on vbox later when Im less pissy 12am now

[CyberClaus]

lol ok, if you need help on that, add me on skype

[Sutz]

oh my god!!! its not my night to night haha!

 

2

 

O.O

Ok powering down an relaxing to some TV will start over 2morra, sorry for wasting your time with this but was bugging be an thought I did something wrong.

[CyberClaus]

You dont bother, i like to help and i love challenges.

[Sutz]

Ok I solved my problem now.

Installed mysql server on vbox an now it connects on 127.0.0.1

 

Seems the LC server files dont support password & connecting to a remote database

[CyberClaus]

password yes, it does MaX, you just need to change a line in my.cnf and put : old_passwords=1

after that it will let you have root user with password. And remote connecting, it has also to work, the problem is that mysql, for security reasons, is too picky, and the configuration has to be done correctly. Im glad you have it working, anything else just ask.

[Jaiz]

install phpmyadmin and go to the users and change the version of the mysql test it yourself.