آموزش تنظیم mysql remote در دایرکت ادمین
1.SSH to your web server as root.
2.Edit /usr/local/directadmin/conf/mysql.conf to add in the IP of the remote mysql server as host:
3. SSH to your remote mysql server, make sure mysql service is installed, you can test it by:
If nothing is showing, you will need to install mysql.
4. Login to mysql service in remote mysql server.
5. Grant full privileged to da_admin.
Take note that 126.96.36.199 is the IP of you webserver, you are granting permission to let the webserver to access to your remote mysql server.
6. Test below command in the webserver to check if webserver can access to remote mysql server now.
7. Final test, Test it out in DirectAdmin to make sure webserver can create and manage databases via Mysql Management.
8. To allow usage of phpmyadmin so that you can manage mysql databases, please edit:
Find this line:
And change it to:
تاریخ ارسال: 2014-01-31
تعداد بازدید: 6903