I have just installed ubuntu on my server and mysql.
I can't make any change in mysql (seeting password, creating database, etc.) as I ALWAYS get an Access denied error message. I have followed the mysql manuals re passwords, but to no avail.
The user name I use is the account name created when ubuntu was installed.
At some point, I am told I need SUPER privileges to do this or that but I can't change the privileges since I get the same error message. I can't even see the GRANTS as I also get the same access denied message. mysql version 14.14 Dist. 5.5.32, for debian-linux-gnu
Any idea on how to solve this?
Editing my own question is the only option I have to post this:
mysql> status mysql Ver 14.14 Distrib 5.5.32, for debian-linux-gnu (i686) using readline 6.2 Connection id: 63 Current database: Current user: charles@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.5.32-0ubuntu0.12.04.1 (Ubuntu) Protocol version: 10 Connection: localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 6 hours 58 min 20 sec Threads: 1 Questions: 165 Slow queries: 0 Opens: 211 Flush tables: 1 Open tables: 51 Queries per second avg: 0.006
Now, I have not been able to create a single database since the installation of the server this morning. I hope that helps. Thanks. :)