Step 2 -> 3 not connecting to mysql database (solved)

[xenon2000]

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111) in /var/www/htdocs/forum/install.php on line 351

Cannot connect to database server with given data!

Please check the information you provided, and then try again.

This is the error I get when trying to continue to step 3. I have a easy successful installed of the same Yabbse 1.51RC1update45 on my remote hosted site. I am now trying to install it on my local Slackware 8.1 linux server at pftb.homelinux.com/forum/
 I am trying to figure out if it's just a mysql database admin setup issue of incorrect user/pass. Or if there is actually something wrong with my php or mysql install on my linux server. Any better ideas? I use Webmin to administer mysql databases. But I like the phpadmin that my remote host uses for mysql database admin tasks. I hope that is enough info to get some ideas flowing. I have been trying to get ideas from other install issue on this board. Thanks for any ideas.

[[Unknown]]

MySQL is not configured properly.

-[Unknown]

[xenon2000]

Thanks. Any ideas what may be wrong? I just installed the latest MySQL 3.23.55 and in webmin it seems that everything functions correctly and no errors. I'm not sure where to start looking since I just installed mysql. I will start doing some more research on mySQL to see if I missed something, or need to reconfigure some part of it.

[[Unknown]]

Sorry, I'm a windows guy.  I've never bothered with MySQL on linux.

You might try messing with your MySQL settings in php.ini....  Really, I don't know..

-[Unknown]

[David]

Start here.

http://www.mysql.com/doc/en/Can_not_connect_to_server.html


I also think #mysql is good on irc.freenode.net.

I think that is the right irc server.

[xenon2000]

Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'yabbse@localhost' (Using password: YES) in /var/www/htdocs/forum/install.php on line 351

Cannot connect to database server with given data!

Please check the information you provided, and then try again.

This is the error if I change "localhost" to "shawnz" (my linux box name). I didn't change anything on my linux box, and yet this error still shows @localhost even though I entered a different host name. And it say PASSWORD=YES instead of NO. Should I still try looking more into mySQL? or does this error mean something a little different?

[xenon2000]

Yeah, I use a Linux server because my host is a linux server and I like to be able to fully test things locally before I make them live on my host. Thanks for the suggestions.

[David]

That means either the mysql username or password is wrong, also could mean the user account does not have enough permissions on the database.

[warren_kid]

I get the same error, except that the ports are different.

[xenon2000]

Well, that makes sense. Since if I leave the password out I get:

Unable to use the provided database, yabbse!

Please double check this information, and try again. Remember, some hosts add a prefix to yuor database name.

So it sounds like my database and/or database user pass/permissions is not configured right. I will focus on that. Thanks for your quick help.

[xenon2000]

Hmm, not figuring anything new out.
Just curious though. Why does it show 'user@localhost' instead of 'user@shawnz' when I specify "shawnz" as the server name in step 2?

[David]

Hmm, not figuring anything new out.
Just curious though. Why does it show 'user@localhost' instead of 'user@shawnz' when I specify "shawnz" as the server name in step 2?

Because shawnz is localhost.

[xenon2000]

k, even though I knew that   I thought that maybe it would show the specified localhost name. oh well. Was hoping that maybe that would lead me in a new direction. Still not figuring out why it says access denied for any user that I specify. Odd that it was so easy to install on my remote host. Guess if I mess with it enough I will get it set right. Wish I knew more about MySQL admin functions. Thanks again for your quick responses and help.

[xenon2000]

Thanks for all the pointers and hints. All solved now. I finally had to use a root user/pass and then it worked. The user/pass that I create specifically for this database must not have been set with the right permissions. But all solved now. Thanks again. Now I can do my site integration and make it live on my host. Thanks!

[Monte-Cristo]

A similar problem here... Trying to install 1.5.1 RC45, and my hosting service provider has the freaking Safe Mode on.

Anway, here's what happens. At step 3, the installer says:
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/customers/nakokulma/public_html/keskustelu/install.php on line 351

What's wrong?