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 |