Author Topic: Connecting to Mysql  (Read 1317 times)

0 Members and 1 Guest are viewing this topic.

Offline vbp6usTopic starter

  • Irregular
  • Posts: 2
    • View Profile
Connecting to Mysql
« on: April 17, 2003, 05:27:48 PM »
Hi,

I have mysql on my linux box and it works fine.  It starts and eveerything.  Im using webmin and there is a button which says \"create new table\".  Then it asks for table, initial table then it asks for width and what it is, ie. text, int etc. . .

Now when im trying to install my invisionboard, it asks for

SQL Host :  localhost
(localhost is usually sufficient)

SQL Database Name: test2

SQL Username: root

SQL Password: *********

SQL Table Prefix(You can leave this blank):

Then i fill out the administration information for the board and hit proceed and get:

The following errors must be rectified before continuing!
Please go back and try again!

Could not create a mySQL connection, please check the SQL values entered

Why is it not connecting??  It\'s running too.  I checked through webmin AND /etc/init.d/mysql status                     running

So...what am i doing wrong??


EDIT:

I just found this at the top of the error page:

I just saw this at the top of the sm_install error page:

Warning: Access denied for user: \'root@localhost\' (Using password: YES) in /srv/www/htdocs/forums/sm_install.php on line 395

Warning: MySQL Connection Failed: Access denied for user: \'root@localhost\' (Using password: YES) in /srv/www/htdocs/forums/sm_install.php on line 395


what does that mean? My root password is right and root is the top level user that can do anything so whats the deal??

Thanks.                    
I use Linux because failure is not an option

Offline effigy

  • Staff Alumni
  • Freak!
  • *
  • Posts: 7,301
  • Gender: Male
  • We must be the change we wish to see in the world.
    • View Profile
Connecting to Mysql
« Reply #1 on: April 17, 2003, 10:35:51 PM »
be sure you didn\'t have capslock on... try the password on the command line and make sure it works. what is on line 395? mysql_connect?                    
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

Offline vbp6usTopic starter

  • Irregular
  • Posts: 2
    • View Profile
Connecting to Mysql
« Reply #2 on: April 18, 2003, 08:24:24 PM »
I think it works now...i don\'t have loopback so i cant test it.  Does it work?

http://forum.asappainting.com

Thanks.    :!:                    
I use Linux because failure is not an option

Offline effigy

  • Staff Alumni
  • Freak!
  • *
  • Posts: 7,301
  • Gender: Male
  • We must be the change we wish to see in the world.
    • View Profile
Connecting to Mysql
« Reply #3 on: April 18, 2003, 08:29:07 PM »
works  :wink:                    
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/