How to register an existing database in Plesk

Follow

Comments

5 comments

  • Avatar
    Ribas

    An additional information is valid, if you have more than one database server to map, for the second command is necessary set as default on which server the database is present, 'Tools & Settings > Database Servers > db server > Settings > Use this server as default for MS SQL`. In such conditions it is possible to explicitly specify the server in the command by adding `-server server.host.name`, for example:

    # plesk bin database --register-dbuser db_user -domain example.com -database db_name -type mysql -user-role readWrite -passwd <password> -server server.host.name

  • Avatar
    Simon

    I am preparing my 12.5 instance to be migrated to Onyx on a new server and this guide helped me a lot!

    In one case I experienced an issue where an existing mysql user is in the format user.name  

    The error I'm getting is always "Database user name is invalid." even if I'm putting the name in single or double quotes. Is there a way I can make the tool accept that type of user name?

  • Avatar
    Alexandr Redikultsev (Edited )

    Hi, @Simon.

    I have just checked this on Plesk Onyx 17.8, and I was able to use such usernames. I created database 'test' and database user 'test.test' and was able to register both database and database user:

    # plesk bin database --register test -domain example.com -server localhost
    The database was successfully registered.
    # plesk bin database --register-dbuser test.test -domain example.com -database 'test' -type mysql -user-role readWrite -passwd ****
    The database user was successfully registered.

    Could you please share the steps you are taking with a little bit more details?

  • Avatar
    Simon (Edited )

    Well then it's probably fixed already in Onyx. As I mentioned I'm coming from 12.5 and that is where I experienced the issue when trying to get all DBs and users registered properly before the migration.

    I could move on by just renaming the user to something without a dot.

  • Avatar
    Bato Tsydenov

    @Simon

    This is expected behavior for Plesk 12.5. It is not possible to create database user with '.' character in the name in Plesk 12.5.

Please sign in to leave a comment.

Have more questions? Submit a request