[mapvivo]

Ah, that makes sense.
Thanks.

[K.Kode]

OVH wouldn't have your SQL password to email to you, use mysqladmin to set a root password.

[mapvivo]

Hi

I just bought a dedicated server and set up a database for my main website.
The user for this database I created does not have "CREATE TABLE" privileges.

I need to import a big database with procedures and triggers from my old website. For that I need root access to MySQL.

I logged in to my server via SSH and tried to run:
mysql -u admin -p
when prompted for password I typed in admin password from email from OVH. The problem is I'm getting:
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

Am I doing something wrong? how can connect to my database as root?

Thanks.