search

xeoncross / lowendscript

Bash scripts to set up/bootstrap low end virtual servers
326 stars 100 forks source link

Can't connect to MYSQL without password #24

Open ovizii opened 10 years ago

ovizii commented 10 years ago

I've setup a root password for MYSQL and now I cannot automatically create a user/db via this script. Any ideas short of removing the password?

./setup-debian.sh mysqluser mydomain.tld mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) MySQL Username: username MySQL Password: password MySQL Database: mydomainy.tld

xeoncross commented 10 years ago

The script assumes you have the password defined in the my.cnf file for MySQL. Just open the file and add your username/password.

[client]
user = root
password = ...

Make sure you chmod 600 the file for security.

ovizii commented 10 years ago

doesn't work. sure it works with this mysql version too?

mysql Ver 14.14 Distrib 5.6.17, for debian-linux-gnu (i686) using EditLine wrapper

ovizii commented 10 years ago

assuming my.cnf needs to be inside /root ?