Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?



Login with username, password and session length
May 25, 2012, 12:56:25 PM

Pages: [1]   Go Down
  Print  
Author Topic: Unclear about what format to use for MySQL database name and user  (Read 630 times)
cupper3
Space Explorer
***
Offline Offline

Posts: 9


« on: December 29, 2009, 04:36:39 PM »

I have created at new MySql database, and it shows up in the format of:

myaccount_newmysqldatabase

Then when I want to create a new user, the format shows as:

myaccount_newusername@000.000.000.00

I am now trying to install a PHP program into that new database. When I enter the database name and account name as shown, with an eight digit password that I have verified, I keep getting error messages that the new program can not connect to the database.

I have tried various iterations of the database name such as "newmysqldatabase" or the user name as "newusername" or as "myaccount_newusername".

None of these iterations have worked.

So, I guess the question is, what IS the database name and what IS the correct format to use for the user name?

thanks!
Logged
katrina1
Guest
« Reply #1 on: December 29, 2009, 10:27:26 PM »

It looks like you are on an LPCP server. DB name is myaccount_newmysqldatabase. User is myaccount_newusername. DB Hostname must be lpsql01.lunariffic.com (NOT localhost on LPCP)
Logged
artcop
Newbie
*
Offline Offline

Posts: 1


« Reply #2 on: January 27, 2010, 09:43:58 PM »

It looks like you are on an LPCP server. DB name is myaccount_newmysqldatabase. User is myaccount_newusername. DB Hostname must be lpsql01.lunariffic.com (NOT localhost on LPCP)

This seems like pretty important information which isn't in the obvious places. I've been wasting a great deal of time trying to connect using the 'old' method..
 Grr..!!
Logged
lexhair
Galactic Royalty
*****
Offline Offline

Posts: 406


« Reply #3 on: January 28, 2010, 07:13:38 AM »

It looks like you are on an LPCP server. DB name is myaccount_newmysqldatabase. User is myaccount_newusername. DB Hostname must be lpsql01.lunariffic.com (NOT localhost on LPCP)

This seems like pretty important information which isn't in the obvious places. I've been wasting a great deal of time trying to connect using the 'old' method..
 Grr..!!

Same thing happened to me when I got an additional hosting account (on an LPCP server). I had to drop a support ticket to figure out what the username was because LPCP either wasn't clear or is in conflict.
Logged
Pages: [1]   Go Up
  Print  
 
Jump to: