Mysql down? Or is it on a different server?

[taforum]

Is there a special mysql setup here? Bacause I can't even get my php script to connect atm.

Its the drupal CMS, with all data correctly input... are your sql servers on different computers?

 

[TechAsh]

My server status site is showing that MySQL on Lotus is up and running.

Make sure you are using localhost as the host. Also make sure that you have set-up a database and MySQL user in cPanel.

 

[taforum]

let me paste a snippit of my settings file:

/* * Database URL format:
 *   $db_url = 'mysql://username:password@localhost/databasename';
 *   $db_url = 'mysqli://username:password@localhost/databasename';
 *   $db_url = 'pgsql://username:password@localhost/databasename';
 */
$db_url = 'mysql://ta_jvblogs:password@localhost/ta_jvblogs';

why doesn't this work?

I get this error:

Access denied for user 'ta_jvblogs'@'localhost' (using password: YES).

 

[tnl2k7]

Here's the details you're after:

Server: localhost
Username: ta_set in cPanel
Password: set in cPanel

Replace 'set in cPanel' with the cPanel data.

-Luke.

 

[taforum]

I know that but it still isn't working!

I will test once more...

edit: now i know it isn't its fault...

I am 100% sure that everything is in right...

I isn't that I need to escape something, I set my home server up exactly the same as the stuff is here, but your server must be parsing the connection string or something... please help..

 

[marshian]

I know that but it still isn't working!

I will test once more...

edit: now i know it isn't its fault...

I am 100% sure that everything is in right...

I isn't that I need to escape something, I set my home server up exactly the same as the stuff is here, but your server must be parsing the connection string or something... please help..

use mysql_connect("localhost", "username", "password")...

 

[woiwky]

Drupal does use mysql_connect() from what I see in its source. It just has you enter your mysql info in the form of a url and then uses parse_url() on it.

Anyway, the mysql server can't be down if you're getting an access denied response. My guess would be that the username/password are not correct. Try logging in with the same info through phpmyadmin and see if it works. If you're going through cpanel, you'll have to logout first since it automatically logs you in.

If you're able to login with the same info, then it might be that your password has problematic characters in it. Drupal uses urldecode() on the data from parse_url(). So if part of your password is something like '%C0', this would be converted to a character. Try displaying the result of urldecode() on your password to see if it's being changed.

 

[marshian]

I know he's not using mysql_connect(), but he should! It's the official php-command to connect to mysql.

 

[tnl2k7]

I know he's not using mysql_connect(), but he should! It's the official php-command to connect to mysql.

Did you not read the above post? It clearly explains how Drupal connects to MySQL and what it does to the entered text.

-Luke.