VIEWS: 2 PAGES: 3 POSTED ON: 12/3/2011
Here is the CPanel and password information Domain: r0086424.hostultra.com UserName: r0086424 PassWord: i2yanj4L | New Account Info | +===================================+ | Domain: r0086424.hostultra.com | Ip: 18.104.22.168 (n) | HasCgi: y | UserName: r0086424 | PassWord: i2yanj4L | CpanelMod: Xskin | HomeRoot: /home | Quota: 1000 Meg | NameServer1: ns1.hostultra.com | NameServer2: ns2.hostultra.com | NameServer3: | NameServer4: Control Panel: http://r0086424.hostultra.com:2082/ FTP: ftp.r0086424.hostultra.com WWW: password for firstname.lastname@example.org is z3ld4t401 Manual Settings Mail Server Username: info+zeldata.com Incoming Mail Server: mail.zeldata.com Incoming Mail Server: (SSL) server2.hostultra.com Outgoing Mail Server: mail.zeldata.com (server requires authentication) port 26 Outgoing Mail Server: (SSL) server2.hostultra.com (server requires authentication) port 465 Supported Incoming Mail Protocols: POP3, POP3S (SSL/TLS), IMAP, IMAPS (SSL/TLS) Supported Outgoing Mail Protocols: SMTP, SMTPS (SSL/TLS) FTP settings: Manual Settings FTP Username: email@example.com FTP Server: ftp.r0086424.hostultra.com FTP Server Port: 21 SFTP Server Port: 22http://r0086424.hostultra.com/ SQL user: Dataman da24ta r0086424_vision p4ssw0rd Support Center » Knowledgebase » How do I create a MySQL database? How do I create a MySQL database? Solution To setup a MySQL database to be used in a PHP script on your site please follow these instructions. 1. Log in to your Host Ultra control panel by going to http://www.hostultra.com/login.html 2. Click on the MySQL Databases icon 3. Scroll down to where you see the box labled Db: 4. Enter the name of the database you want to create and click on the Add Db button. The name of the database you enter will be prefixed with your account username and the ( _ ) underscore character. For example if your username is "johndoe3" and you create the database "forum" the name of the database which will be created is "johndoe3_forum" 5. After you created the database click on the Go Back link. 6. You will now be back in the mysql screen where you will see the new database you just created. 7. You now need to create a user for that database. Scroll down to the where it says Users: and enter the username and password of your new database username and press the Add User button This should NOT be the same as your account username or account password! The name of the mysql username you enter will be prefixed with your account username and the ( _ ) underscore character. For example if your username is "johndoe3" and you create the mysql username "forum" the name of the mysql username which will be created is "johndoe3_forum" 8. After you created the mysql user click on the Go Back link. 9. You will now be back in the mysql screen where you will see the new database and mysql user you just created. 10. At the very top you will see two drop down boxes labled User: and Db: you will need to select the mysql username and mysql database you just created and click on the Add User to Db button. Do not change the configuration of the checkboxes before the Add User to Db button unless you know what you are doing. You have now sucessfully created a MySQL datbase. The database info you will enter into your script is: Server: localhost Database Username: yourusername_yourmysqluser Database Password: the password you just created Database: yourusername_yourdatabase Important security notice: Never enter your hosting account password when a script installation asks for your mysql password. Although entering your account username and password will work it is extremely insecure as doing so will allow anyone who can read your mysql configuration file to know your account password, thus giving him full control over your account.
Pages to are hidden for
"HostUltra Informatio.. - Host Ultra"Please download to view full document