I'm trying to do a backup of a MySQL database on Windows, but for some reason it's trying to log me in as ODBC instead of root - does anyone know why?
As you can see below the red line, I can login to MySQL no problem.
asked Sep 4, 2014 at 10:41
2 Answers
The only thing I can suggest is to explicitly choose a host by doing one of the following:
mysqldump -hlocalhost -uroot -ppassword ideal_inv > ideal_inv.sql
mysqldump -h127.0.0.1 -uroot -ppassword ideal_inv > ideal_inv.sql
answered Sep 4, 2014 at 15:34
In the end I couldn't get mysqldump to login as root, it kept trying to login as ODBC. Instead I added this to my my.ini file and ran the command without user/password arguments:
[mysqldump]
user=root
password=XYZ
answered Feb 8, 2015 at 18:36
root@localhostfor both.SELECT user,host,password FROM mysql.user WHERE user='root';. Questions: 1) How many root users are there ? 2) Do all root users have the exact same encrypted password ? 3) Do any of the root users have a blank host or blank password ?ODBCuser, notroot. Thanks for your help, I appreciate it!my.inihave a[mysqldump]section ? If so, please post it (hiding the password if supplied).mysqldump -uroot -p ideal_inv > ideal_inv.sql. Does it prompt for a password ? Does it run when you give it the right password ?