+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Off-Topic (The Outer World) (https://lckb.dev/forum/forumdisplay.php?fid=198)
+---- Forum: General Discussion (https://lckb.dev/forum/forumdisplay.php?fid=147)
+---- Thread: Error not connect to DB (/showthread.php?tid=363)
Pages:
1
2
- maxig - 11-05-2012
hi guys, took 3 days trying to run the server. left image
i use Navicat and Sql.
Thanks
- iFlash - 11-05-2012
Thats where im stuck too, i can't get the files to connect to the db. Maybe is my phpadmin,mysql, my db name is too long, idk. I need some advice on this part as well.
- Koko - 11-05-2012
Don't use any password for mysql, from what i've heard that might cause this.
- iFlash - 11-05-2012
Ok ill try again later, thanks.
Don't use any password for mysql, from what i've heard that might cause this.
It worked! haha, thanks man, made my day. Just wanna give u a big wet kiss... xD
- Koko - 11-06-2012
Ok ill try again later, thanks.
It worked! haha, thanks man, made my day. Just wanna give u a big wet kiss... xD
*runs & hides*
- SKY - 11-06-2012
hi guys, took 3 days trying to run the server. left image
i use Navicat and Sql.
Thanks
i have the same problem
- iFlash - 11-06-2012
Set your Mysql empty. If you need to know how , search abit, someone posted about it yesterday. Or just google it.
- pwesty - 11-29-2012
im having the same issues ive tried and tried and tried changed user name created users with all the available ips to connect but still says cannot connect to DB!! all my mysql users even root have no password set as i did when doing the mysql install any idea why it wont connect even though no password is set?
- pwesty - 11-30-2012
guess there is not edit option for my last post but more information maybe could guide you into helping me
[server]
Number=1
IP=127.0.0.1
Port=4100
[Char DB]
IP=127.0.0.1
DBName=newproject_db
User=root
Password=
this is how i have the helper setup i also turned off iptables and still no go keeps saying cant connect to DB!!
- blade5000 - 12-01-2012
Resetting MySQL Root Password: Red Hat and CentOS
If you've forgotten your MySQL root password (or are involved with some nefarious activity), here is how you can reset that password on a Red Hat (RHEL) system or a CentOS system:
Stop MySQL:
root# service mysqld stop
Start MySQL in safe mode:
root# mysqld_safe --skip-grant-tables &
Log into MySQL as root:
root# mysql -u root
Reset the password:
mysql> update mysql.user set password=PASSWORD("YourNewPassW0RD") where User='root';
mysql> flush privileges; exit;
Log out of MySQL and stop the Safe Mode:
root# service mysqld stop
Start MySQL in the normal mode:
root# service mysqld start
Log into MySQL with your new password:
root# mysql -u root -p
Enter password:
mysql>