No mysql root password for my VPS ?

[lamnk]

I need mysql root password for a backup script but this is what support told me:

the 'root' access for root user of MySQL in Plesk control panels are disabled

Instead of using admin password of MySQL server in the script please use the Database User's login and password who has prvillages to access the database.

I don't understand much what they mean here. Why couldn't i have the root access for mysql server ? Is that plesk's restriction ?

Let say i have 10+ databases then i must insert 10 users/passwords in my backup script to dump the databases ?

[thisisit3]

I'm using cPanel, so i'm not the best person to answer your question.

Based on the error message, i'd say that Plesk has restricted access for root (many people do that, since its not very frequent that "root" is required for MySQL).

If you want to access many different databases at once, then root access is what you need. Why don't you look at Plesk's configuration and see if you can enable root access to MySQL? Just make sure you set a proper password.

[the_ancient]

goggle people

http://kb.swsoft.com/article_23_427_en.html

[PsyCHZZZ]

the_ancient is right... Plesk disables the "root" account on default. So, just login via cli to your MySQL using the "admin" account and then if you want... you can add your own "root" account.

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'
    -> IDENTIFIED BY 'root_password' WITH GRANT OPTION;

[lamnk]

Heck ... it's so simple

Thank you folks.

[thisisit3]

This is why people don't like Plesk, it messes with the commonly known "defaults" and other Linux standards (like paths/locations of files/etc).

[Smithjp]

You can also login to MySQL prompt via admin user directly as:

mysql -uadmin -p`cat /etc/psa/.psa.shadow`

[the_ancient]

the_ancient is right..

Ofcourse I am, the_ancient is never wrong

[PsyCHZZZ]

Ofcourse I am, the_ancient is never wrong

Woah... the ego.... hahaha...

[PsyCHZZZ]

This is why people don't like Plesk, it messes with the commonly known "defaults" and other Linux standards (like paths/locations of files/etc).

You got a point... I'm getting a bit annoyed at how Plesk places all the www root folders and naming them differently from what I was so used to when I'm on Cpanel and just plain *nix boxes.

But i just gotta live with it for now... heck, it's free so beggars can't be chooser! hahaha...
(I meant to refer to myself of course... not to others).

[lamnk]

Uhm ... but there are quite many people who love plesk, no ? What are the advantages of plesk over cpanel then ?

[Gwaihir]

Uhm ... but there are quite many people who love plesk, no ?

By open choice or necessity? My impression is that people pick Plesk because:
- cPanel doesn't run on Windows and they have Windows VPS / dedicated
- they previously used a host that offered only Plesk and are comfortable with it

[lamnk]

I do mean by open choice.

There are tons of complaints about cpanel being unstable on WHT. I don't see Plesk has that many complaints.

[JPC-Masood]

I do mean by open choice.

There are tons of complaints about cpanel being unstable on WHT. I don't see Plesk has that many complaints.

May be because plesk does not have that many users. All control panel have problems. There is no perfect system out there.