11/13/2023 0 Comments Phpmyadmin connect to remote database0.16", but when I try to delete the database, it prompts the error "ERROR DELETING DATABASE(S) Error clearing the database from the mysql. If I change the access_host to "10.0.0.16", everything works fine when I create the database admin_test5, and check that a database named admin_test5 is also created in the database, as well as 2 accounts named admin_test5 with permissions of "localhost" and "10.0. * FROM There is no such grant defined for user 'admin' on host '10.0.0.17' Error clearing the database from the mysql.db table: Access denied for user to database 'mysql'" 0.17", but when I try to delete the database, it prompts the error "Error with query: REVOKE ALL PRIVILEGES on `admin\_test5`. If I change the access_host to "10.0.0.17", when I create the database admin_test5, everything works fine, and a database named admin_test5 is also created in the check database, and 2 accounts named admin_test5 are also created with permissions of "localhost" and "10.0. My DA panel server LAN ip is "10.0.0.16" and the remote Mysql LAN ip is "10.0.0.17". Question 2: How do I uninstall the database on top of da server and use only the remote database? Question 1: How do I solve the problem I described above Request 2: Can I give you my server confidential information and help me uninstall mysql that comes with da panel, because I want to implement - install DirectAdmin without MySQL and use only remote MYSQL Request 1: Can I give you my server confidential information and ask you to help me check where I made an error during the installation The error prompts are exactly the same for the root user and da_admin user using the remote database. Situation 2: I created a database named admin_test2 in the da panel database management module, in phpmyadmin, delete the admin_test2 database, prompt: Success.Ĭase 3: I created a database named admin_test3 in da panel database management module, and deleted the admin_test3 database in Navicat Premium 16, prompt: Success.Ĭase 4: I created a database named admin_test4 in the da panel database management module, and used the command line to connect to the remote database in the server where da panel is located, and used the command line to delete the admin_test4 database, prompt: Success. While there are ways to allow access to the phpMyAdmin tool, the owner needs to do a bit of setup and sacrifice more space on the account. Situation 1: I created a database named admin_test1 in da panel database management module, in da panel database management module, delete admin_test1 database, prompt: ERROR DELETING DATABASE(S) Error clearing the database from the mysql.db table: Access denied for user to database 'mysql' This can hinder the developer from working on specific things such as the database. PhpMyAdmin will do the rest, using the provided info to establish a connection to the remote host/server, and manage the remote database(s) as if they where local.Click to expand.Sorry, I do not know English, I can only use the translation software to communicate with you, please forgive me。 Select from the “Current Server” drop-down: Remote Server Name Do not modify anything else in the file. Update for the host (address of remote server), server name (can be anything – used as display name), and the MySQL’s account user + password info. $cfg = '^(mysql|performance_schema|innodb|information_schema)$' Connecting phpMyAdmin to Remote ServerĮdit phpMyAdmin’s configuration file (\WampDeveloper\Tools\phpMyAdmin\), and at the end of it, before the ending ?> line, add in – /* Remote Server */ The local computer needs to have a fully working phpMyAdmin environment installed (such as WAMP-Developer Pro). ‘ ALL‘) granted on the database(s) you need access to (e.g., GRANT ALL PRIVILEGES ON `database`.* TO The remote server’s firewall should be configured to allow inbound and outbound port 3306 TCP connections.Ĥ. This account also has to have at least the minimum set of permissions (‘ SELECT‘ vs. The remote MySQL user account has to have its ‘Host’ field set to either “%” (means any IP can connect) or to your public IP address. ![]() Some cloud-based VM providers might also require you to connect public:3306 to private:3306 (i.e., “endpoints” on Azure).Ģ. ![]() The remote MySQL server must be listening on a publicly accessible IP address (usually my.ini has MySQL bounded to 127.0.0.1 – which will not see outside connections). Accessing and managing a remote MySQL database from a “localhost” phpMyAdmin is very simple.ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |