All available tables are shown in the lefthand sidebar. Once you are logged in, click on the drop-down menu at the top left of the Sequel Pro window. Choosing a database and tables to administrate The first group of connection settings relate to the database you are connecting to, so you use the same It’s the same username and password combination you used when you linked software (like Armadillo, Wordpress, Concrete5 or Piwik analytics) to your database. These settings are all used to verify that you are the genuine owner of the database, which you are connecting to. To summarise, the SSH settings are normally identical to those which you use to login to CPanel and which you see displayed in CPanel. If the settings appear to be correct, click on the Save Changes button, to save all of these settings as a bookmark. This is the port number on the web server firewall, to which a tunnel will be created and the database can be connected to. This is the same password you use, when signing into CPanel. This is the same username you use, when signing into CPanel. It is the same domain name you used when you signed-up to Chillidog Hosting. The SHH Host is your primary / main domain name (the same one shown in the sidebar in CPanel). You have an opportunity shortly to choose a database and tables from a drop-down menu. This is optional and can normally be left blank. Similar to above, this is the password of the user your created, during creation of your MySQL database. Here you will see a list of users assigned to each database. If you are not sure what username you gave your database, log into CPanel, scroll down to the Databases section and click on MySQL Databases. Typically it is your CPanel username, followed by an underscore character, and the username of the database. This is the username you created, when you created the new MySQL database in CPanel. Typing something like ‘Chillidog’ will do fine. This is the name of the bookmark to be created, storing your connection details. Click on the SSH tab and follow these instructions carefully and refer to the screenshot as an example: Sequel Pro Conenction Settings Click File > New Connection if the new connection window is not shown automatically. Once you have setup your IP address in Remote MySQL, launch Sequal Pro on your computer. Sequel Pro includes all the basics for simple database administration tasks, and a large collection of sophisticated tools for expert power-users. The connection to the database is made via SSL, so it is extremely secure. It works a bit like FTP software, and lets you connect remotely to a web server and access your MySQL databases. Sequel Pro is a free (dontationware) application which you download and install on your computer. Or you may find that you just want to periodically backup or export a database for safe-keeping.Īlthough you can already login and administrate databases through PHPmyAdmin (in your control panel), it is fair to say that this can be a bit tedious and the administration panel is not exactly 21st century! So some people prefer to use their own software. Wordpress sometimes needs settings changed in the database. For example, software like Concrete5 might require you to edit a database to change ownership of a website. Sometimes databases require administration or maintenance work doing to them. Chillidog Hosting has taken a more relaxed approach, and we welcome any customers (on any hosting plan) to access and administrate MySQL databases remotely. Quite a number of cheap web hosting companies ban their customers from accessing MySQL databases directly using software such as Sequel Pro, unless customers pay extra for business hosting accounts or move to dedicated servers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |