Set Up Remote WordPress Credentials and Database To force MySQL to read the new change that we’ve just implemented, we can restart the database: sudo service mysql restart Save and close the file when you are finished. Otherwise, you can use the public IP address here: bind-address = your_database_IP If you are hosting this in a datacenter with private networking capabilities, use your server’s private network IP. We need to change that to reference an external IP address that your server can be reached at. This basically tells the database software which network address to listen to connections on.Ĭurrently, MySQL is configured to only look for connections from its own computer. Within this section (in the area between this tag and the next section marker), you’ll need to find a parameter called bind-address. This file is divided into sections denoted by words in brackets (). Open up the main configuration file for MySQL with root privileges in your editor: sudo nano /etc/mysql/my.cnf Now that you have your database up and running, we need to change some values to allow connections from other computers. To all of the additional questions, you should just hit ENTER to select the default options which will remove some test databases and lock down access. Type “N” for no if you’re happy with your current password. Afterwards, it will ask if you want to change that password. You will have to enter the MySQL administrator’s password that you set in the steps above. sudo mysql_install_dbĪfterwards, we should tighten up security a little bit by running a script that will ask us about disabling some insecure defaults: sudo mysql_secure_installation When you are finished, you need to run the database installation command, which will generate the appropriate directory structure to manage your components. You will be asked to select and confirm a root password for MySQL during the installation procedure.
#Sqlyog for ubuntu 12.04 update
Start off by updating your package cache and installing the MySQL server: sudo apt-get update These will basically be most of the same steps you’d take for setting up a database for a traditional LEMP stack, but we won’t need all of the components (some will be on the other server).
#Sqlyog for ubuntu 12.04 install
To get started, we’ll need to install some basic packages on our database server. It also provides the basic structure necessary to load balance and expand your set up even more at a later time. Having our data stored on a separate computer is a good way to expand gracefully when you’ve hit the ceiling on a one-machine configuration. To get started, we’ll configure one VPS instance as the MySQL server. We’ll be doing all of this on an Ubuntu 12.04 VPS instance for our demo. We’ll configure Nginx on our web server and then connect it to a MySQL database on a remote machine. We will be using WordPress as an example so that we have something to work with.
#Sqlyog for ubuntu 12.04 how to
In this guide, we’ll discuss how to configure a remote database server that your web server can connect to for dynamic content. If you are currently hosting your web server and database backend on the same VPS, a good idea may be to separate these two functions so that each can operate and grow on its own machine. As your application or website grows, you may come to the point where you’ve outgrown your current setup.