Help - Search - Members - Calendar
Full Version: Mysql Hostname
Zymic Webmaster Forums > Zymic Free Web Hosting > Databases & MySQL
Chak
What is MySQL full hostname? I've problems if use localhost as hostname.
swordz
Then I'm afraid you have other problems, as localhost is right. What's your full connection details other than password?

swordz
Chak
Thanks for your reply. I try to install WordPress but I obtain a database error. I've checked MySQL parameters and it's all okey. In fact, I can use SQLMyAdmin without problems.
swordz
localhost is correct - unless you post your connection data we can not help you further. I suspect that your database and user names are longer than 16 characters, but I can only be sure of the problem if you post your data.

swordz
mdepiere
I'm having similar problems.

I created a database and user as requested.

database name is markethigns_wordpress
user name is markethingns_mdepiere
pass you don't need hopefully.

I've assigned all the privileges.

This code I copied into my wp-config.php file:

CODE
// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'markethigns_wordpress');

/** MySQL database username */
define('DB_USER', 'markethigns_mdepiere');

/** MySQL database password */
define('DB_PASSWORD', '***pass***');

/** MySQL hostname */
define('DB_HOST', 'localhost');

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');


I get an error.
Can you help me out?
swordz
markethings_ is 12 characters, so the part after the _ can be a maximum of 4 characters long, whereas wordpress is 9 and mdepiere is 8.

swordz
mdepiere
QUOTE(swordz @ Dec 17 2008, 12:01 PM) *
markethings_ is 12 characters, so the part after the _ can be a maximum of 4 characters long, whereas wordpress is 9 and mdepiere is 8.

swordz


Thanks for the quick reply but...

I don't fully understand. What should I replace with what then?
swordz
You need to recreate your database and user. Use markethings_word for the database name and markethings_mdep for the user name.

swordz
mdepiere
thanks a lot, that did the trick!
tacgnol
Yes, Wordpress does not like long DB/ User names over 16 characters. Make sure you count how many and keep it 16 or less and it will work.

If the beginning part of your "subdomain".vndv.com equates to over 16 characters or close to 16 characters, you might want to shorten or make a new shorter subdomain. You will only have the option in the case of wordpress to make a short DB name such as " Subdomain_usr" where it will be counted as 13 characters. You see how that works? Enjoi smile.gif
bluishberry
QUOTE(tacgnol @ Jan 5 2009, 09:40 AM) *
Yes, Wordpress does not like long DB/ User names over 16 characters. Make sure you count how many and keep it 16 or less and it will work.

This help a lot. Thanks
The Living Legend
Can't help but feel I'm doing something else wrong... I had this exact same issue until a couple of seconds ago when I replaced the following:

DB Name: weareblogging_wawblog
Username: weareblogging_wawadmin

...with...

DB Name: weareblogging_wb
Username: weareblogging_wa

...and I'm still receiving the same database error. Should the "localhost" part be replaced with anything, such as the path leading to the index file (I'm also trying to install wordpress, btw smile.gif )?

The rest of the code is identical to what mdepiere submitted so I didn't see the point in wasting real estate on another copy of it biggrin.gif )

Thanks in advance,

LJ
swordz
Post the exact error?

Check the password. Have you assigned privileges?

swordz
The Living Legend
Ok... this is what I have now, in the wp-config file:

CODE
// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'weareblogging_wb');

/** MySQL database username */
define('DB_USER', 'weareblogging_wa');

/** MySQL database password */
define('DB_PASSWORD', '---password---');

/** MySQL hostname */
define('DB_HOST', 'localhost');

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');


Both the database name and username are exactly 16 characters long, and yes I have assigned priviliges (all of them) to the database/username combo above, but when I try to access the install script inside the wp-admin folder I still get the database error page:

QUOTE
Error establishing a database connection
This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at localhost. This could mean your host's database server is down.

Are you sure you have the correct username and password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?
If you're unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.


I realise this is a wordpress issue so I do appreciate any help given on this biggrin.gif
Tenzency
Hey,

I want to instal "concrete5.2.0RC1" cms, and it is shouting at me like this:
"Unable to connect to database."

Name of database and it's user is ok, I know it.
There are both under 16 characters.

The last thing is "Database Information -Server"
so I've got to wirte a server name and adress, about what I don't have any idea about.

Can you help me? laugh.gif
"localhost" isn't working here. dry.gif

("concrete5.2.0RC1" is a brand new cms.. )
The Living Legend
QUOTE(swordz @ Dec 16 2008, 06:56 PM) *
Then I'm afraid you have other problems, as localhost is right.


Sorry swordz, but there's a strong possibility that localhost doesn't work for everyone who's using this platform. I've been discussing this with someone who's worked on the WordPress project, and he himself insist's that he's had this same issue with a number of webhosts, and the only solution was to replace localhost with the "actual address of the database".

All you have to do is give us a generic example of what the address should be, informing us of where to enter our account/database specific details... It shouldn't be this painful, or take so long, to install a script! hunter.gif
swordz
This server has been set up to not accept outside connections. If you put the address it appears like an external connection. So gets blocked.

localhost has worked for thousands of users so far. What makes your installation different?

swordz
The Living Legend
QUOTE(swordz @ Feb 6 2009, 02:26 AM) *
localhost has worked for thousands of users so far. What makes your installation different?


You seem to be of the impression that it's an isolated incident, when it's clearly anything but. Yes, many people have (eventually...and after having to hack their way through dry.gif ) managed to get their databases working, but many others still aren't able to, despite doing everything correctly (as varified by an experienced WordPress developer). This leaves the blame solely on the server side of things.

Someone mentioned before that you rely on an external source to provide the control panel, so how can you be sure you're fully aware of all it's flaws and bugs, and the exact effect they may or may not have under individual circumstances? huh.gif

And if what you say is true, that anything other than localhost will be automatically blocked, what harm could it possibly do to provide the generic database address and allow us to try it for ourselves (do you even know what it is?)???

I apologise if this comes across as disrespectful, but I personally feel that's how we're being treated, as mere insignificance's when as admin you should be thoroughly investigating the issue first hand, and publishing all the info inside the forums for us to see, which in turn will ease our own anxiety (knowing that the admin is actually trying to help has a huge possitive impact on everyone else) and you'll have less people asking the same question's over and over again! rolleyes.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.