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?
To Arka:
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. :)
mysql
one ? Do you know your MySQL root password (it's not the same as the system's root password) ?