I've got a mysql server running on ubuntu virtual server.
I want to access the database from my host computer. (I can already access a web site from the host, so I know there's a connection between the 2).
I have only changes one thing about the config file. The IP address. I've changed it to 127.0.1.1 this is the same address I use to view the server web pages from my host.
I'm having 2 problems.
I can't connect to the mysql server from the host computer.
When I access my server terminal, I can enter
$mysql -u mysql and I'm given the mysql prompt.
From there, i can view the default tables "test" and "information_schema". I can even create tables on the database "test"
but when I try to create a user or create a database i get the following error.
1044 access denied for user ''@'localhost'
I don't know why it thinks my user is ''.
I'm logged in to the server as my user account. and then i logged into mysql server as "mysql" (which was just what it was set to in the config file. Also, if i try to use mysqladmin I get told i need SUPER privs. how do i set these up? Any ideas why this isn't working?