Can't connect to MYSQL without password

[ovizii]

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]

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]

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]

assuming my.cnf needs to be inside /root ?