Connection Settings for MySQL
From Lunarpages Web Hosting Wiki
The hostname to connect to is "localhost" if connecting from a script on the server, or your domain name for connecting remotely.
All of our LPCP accounts use a separate database server. You can find the database connections in your welcome email, or by logging into LPCP and setting the hostname to the IP of your MySQL server:
At this time the database server you might need to use could be:
- lpsql01.lunariffic.com 220.127.116.11
- lpsql02.lunariffic.com 18.104.22.168
- lpsql03.lunariffic.com 22.214.171.124
- lpsql04.lunariffic.com 126.96.36.199
- The database name and username need to be entered exactly as they appear in the MySQL manager in your control panel (ie, exmpl5_dbname). The password is the one you specified when creating the username.
- When you create a username in cpanel, please be aware that there is an 8 character limit. Extra characters will be dropped.
- Also, you can have more than one username for a database. If you forget your user password, you may either find it in the script's config file or add a new user to the database and edit the script's config file.
- Please make sure you have added the database user to the database. You must select the user and the database from the drop-down lists and then click on the Add User to DB button. You should see connection code provided if you have done this.
- For best results if connecting remotely and if you do not have a static ip address, you need to add a single % sign or your IP address to the access host list in the MySQL manager.
- The port is 3306.