Need to create a database server MySQL

Collapse

Unconfigured Ad Widget

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • zayn_william
    Senior Member
    • Apr 2022
    • 106

    Need to create a database server MySQL



    Heyy everyone,


    I want to create a database server. But I get one server error. Like, SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES)

    The database can then be seen in the overview. When I try to add a database, I get this message: Error: No database servers are available for this subscription. I have done this before, but now facing this issue.

    Is there anyone who can suggest me a solution?
  • Delaney martin
    Senior Member
    • Jun 2022
    • 102

    #2


    Hello Zayn,


    I think two types of errors can be seen while adding the database server.
    Access denied for user ‘admin’@’mysql server IP’ to database or Access denied ‘server IP address is not allowed to connect to this MySQL server.

    However, By Default, a Connection to the MySQL server is allowed from the Localhost. Only in one condition the Plesk server should be connected to a remote MySQL server, Where, which is supposed to allow access to the MySQL server. Here, the user can manage the databases from Particular IP addresses.

    And as you have said, it shows errors like Database servers are not available for this subscription. So that error has to be something dealing with your current hosting plan. And I would still suggest you ensure that Port 3306 is opened on the server which is running the MySQL server.


    Let me suggest you some simple steps to try,

    - Using CLI on the database server, Enter in MySQL database.

    - Verify if the admin user already exists on the server.

    - If the user doesn't exist, then create and otherwise skip it.

    - Now you can run the mentioned queries,


    MYSQL_LIN: mysql> GRANT all ON . to admin@’plesk_server_IP’;

    mysql> FLUSH PRIVILEGES;

    Now, Keep in mind to replace the Username and passwords with actual Admin and Plesk server IP with Actual IP addresses.

    Comment

    Working...
    X