Not sure if this is the proper forum, but I'll start here....
I just installed MySQL 5 in Debian Linux and have a question regarding root access. I followed the installation instructions to a tee and can confirm that the server is running. The one issue that I'm finding is that I can only run the core mysql applications (mysql, mysqlshow, mysqladmin) only as the Linux root user AND if I explicitly state the hostname with the -h option. If I try and launch these apps with any Linux user other than root OR if I don't specify the hostname, I get the following error:
prompt> mysql -u root -p mysql
"Access Denied for user ''@'localhost' (using PASSWORD:YES)"
If I type the following, I can get in:
prompt> mysql -u root -p -h [myhostname] mysql
Again, even as Linux root user, if I don't specify the hostname I get the same error message.
Not sure what I need to do to resolve this....or is this even an issue?
Just for reference, here's some other information:
"select user, host from user" on mysql database, I get the following
root | 127.0.0.1
root | localhost
root | [myhostname]
My /etc/hosts file looks like
127.0.0.1 localhost localhost
18.104.22.168 [myhostname] [myhostname]
Based on all the documentation I've read so far, not many installations require the -h option. Just want to make sure I don't run into any connection problems when I start connecting this instance to my java app through the connectors.