 |
16 Character Limitation On Mysql - Help! |
 |
Member Login
Welcome
Welcome to the Zymic webmaster forums. Our forums are here to provide people the free ability to discuss a range of websites related topics such as design, development coding and marketing.
In order to post you will need to register for a zymic account or if you already have one simply login by using the form on the left.
 |
Zymic Webmaster Forums Zymic Free Web HostingDatabases & MySQL |
 |
  |
 Jul 9 2008, 11:15 PM
Post
#1
|
|
|
Newbie  Group: Members Posts: 5 Joined: 8-July 08 Member No.: 44,370  |
OK..I have been reading the forums for a while now and I am figuring out that you SHOULD have a limit
of 16 characters or less for database name including your host name?? or Just the dabase name after your host name ex: hilproductions_portfolio <- 8 characters without the hostname ex: hilproductions_db <- 2 characters for dbasename and 14 characters hostname = 16 total... Why am I asking??? well no matter what I do, I cannot connect to mysql using joomla install.... Yes...I have deleted and recreated dbase and usernames..... Yes..I have checked and rechecked my setup with joomla.... I have noticed that I did create another database and when connecting using PHPadmin...Its NOT there.... any help is appreciated....thanks! 
Attached File(s)
Joomla_details.jpg ( 89.38k )
Number of downloads: 61
Joomla_Error.jpg ( 49.04k )
Number of downloads: 58 |
 |
 
|
|
Jul 10 2008, 08:06 PM
Post
#2
|
|
 Outrageously Uber Ninja Group: Moderators Posts: 835 Joined: 10-April 08 From: England Member No.: 18,404 |
At the moment it is restricted to 16 characters in total (including your site prefix and the username).
Use a single letter for the username for your best chance of it working. |
|
|
|
|
Jul 10 2008, 11:51 PM
Post
#3
|
|
 Hosting Abuse Staff Group: Moderators Posts: 2,933 Joined: 14-February 08 From: Fort Myers FL, USA Member No.: 10,089 |
Yes the underscore counts as a character.
so hilproductions_db is actually 17 characters. hilproductions_d is 16 try that. If that doesn't work you're going to have to create a smaller subdomain name |
|
|
|
|
Jul 11 2008, 12:39 AM
Post
#4
|
|
|
Newbie Group: Members Posts: 5 Joined: 8-July 08 Member No.: 44,370 |
Ok...I appriciate that...will try and let you guys know!!
|
|
|
|
|
Jul 11 2008, 01:02 AM
Post
#5
|
|
|
Newbie Group: Members Posts: 5 Joined: 8-July 08 Member No.: 44,370 |
OK...I pulled the last 3 hairs on my head....I give up!!
Not working still.... soooooooooooo.....Guess I will have to go back delete my domain and reduce it to 6 letters....being that, thats how the mysql name is created.... However, I do appreciate you guys helping out.....great Idea, just didn't work....thanks. I have included the images so that you can see for yourself... take care. 
Attached File(s)
Joomla_2nd_Attempt.jpg ( 197.49k )
Number of downloads: 65
Dbase_2nd_attempt_Failed.jpg ( 77.79k )
Number of downloads: 60 |
|
|
|
|
Jul 11 2008, 01:06 AM
Post
#6
|
|
|
Hosting Abuse Staff Group: Moderators Posts: 2,933 Joined: 14-February 08 From: Fort Myers FL, USA Member No.: 10,089 |
Two questions are you SURE your password is correct, and are you SURE you added the priveledges to your database and username in ZHCP? Maybe a screen shot of your ZHCP MySQL settings page will help make sure you aren't making another error.
|
|
|
|
|
Jul 13 2008, 04:37 AM
Post
#7
|
|
|
Newbie Group: Members Posts: 10 Joined: 5-July 08 Member No.: 42,990 |
I see that in the picture the database name is wrong
Is not hilproductions 1, but hilproductions_1 Try again |
|
|
|
|
Jul 13 2008, 06:33 AM
Post
#8
|
|
|
Hosting Abuse Staff Group: Moderators Posts: 2,933 Joined: 14-February 08 From: Fort Myers FL, USA Member No.: 10,089 |
QUOTE(digo @ Jul 13 2008, 12:37 AM)  I see that in the picture the database name is wrong Is not hilproductions 1, but hilproductions_1 Try again No YOU try again. Look at the picture again. He has hilproductions_1 |
|
|
|
| |
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users) |
|
| 0 Members: | ||
|
Forum Jump |
|
| Lo-Fi Version | Time is now: 19th May 2013 - 08:51 PM |