Then next to "MySQL server listening address" select "All" (defaults is 127.0.0.1/localhost). Once you are in select "MySQL Server Configuration". You'll then need to use your MySQL root password to get access. TBH I haven't tested doing it with Webmin but it should be possible.įWIW if you log in via SSH (using an SSH client like PuTTY if you are on Windows) then it should be as simple as copy pasting the above commands in and then is should all just work.īut if you would rather use Webmin, then when you are logged into Webmin, from the top bar select "Servers" > "MySQL Database Server". Restart PostgreSQL for the changes to take effect: # Accept all IPv4 connections - CHANGE THIS!!! # configure postgres to accept remote connectionsĬat > /etc/postgresql/8.3/main/pg_hba.conf <<EOF Sed -i "s/#listen_addresses = 'localhost'/listen_addresses = '*'/" $CONFĬonfigure PostgreSQL to accept remote connections (from any host): Restart MySQL for the changes to take effect:Ĭonfigure PostgreSQL to listen for remote connections:ĬONF=/etc/postgresql/8.3/main/nf Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv ,Ĭreate_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv ,Ĭreate_user_priv, ssl_type, max_questions, max_updates, max_connections , Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv , Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv , Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv , $MYSQL_BATCH -execute "INSERT INTO er ( Host, User, Password, Select_priv , MYSQL_BATCH="mysql -user=root -password=$MYSQL_PASS -batch" Sed -i "s/^bind-address/#bind-address/" /etc/mysql/my.cnfĬonfigure MySQL to accept remote root connections (from any host (' %')): $MYSQL_BATCH -execute "GRANT ALL ON *.* TO -execute "GRANT ALL ON *.* TO MySQL/MariaDB for the changes to take effect: $MYSQL_BATCH -execute "CREATE USER IDENTIFIED BY \"$NEW_PASS\" " Sed -i "s/^bind-address/#bind-address/" /etc/mysql//50-server.cnfĬreate 'new_user' (password: 'MyNewPassword') with permissions to connect to any MariaDB (drop in MySQL replacement) database on this server from any remote address (from any host ('%')): (Note: v15.x = Debian 9/Stretch - See below for v14.x and earlier) Older releases (no longer supported) - v14.x and earlierĬonfigure MySQL/MariaDB to listen for remote connections:.I have disabled the iptables service on the CentOS already. After using wireshark and tcpdump, I found that the server (the Cent OS) keep resetting the connection. $cfg = false įurthermore, I can access the webpage that stored in the CentOS from my other computer without problems. * Select mysql if your server does not have mysqli */ Below are some of the current configuration. However, when I type on my other computer in the same LAN with the CentOS, the browser simply cannot access the page. I can access and login to the myphpadmin on my localhost. I have setup the myphpadmin on my CentOS 6.4 recently.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |