+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep2 Support (https://lckb.dev/forum/forumdisplay.php?fid=166)
+------ Forum: Solved Topics (https://lckb.dev/forum/forumdisplay.php?fid=144)
+------ Thread: libmysqlclient error (/showthread.php?tid=2078)
- Sutz - 06-25-2013
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 - 06-25-2013
XD well try it, cause that means nothing
- CyberClaus - 06-25-2013
MaX, install the server on centos, and use your loopback, mysql will never reject a localhost connection
- Sutz - 06-25-2013
didnt work!
I giveup lol will try install mysql on vbox later when Im less pissy 12am now
- CyberClaus - 06-25-2013
lol ok, if you need help on that, add me on skype
- Sutz - 06-25-2013
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 - 06-25-2013
You dont bother, i like to help and i love challenges.
- Sutz - 06-26-2013
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 - 06-26-2013
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 - 06-28-2013
install phpmyadmin and go to the users and change the version of the mysql test it yourself.