[WNYLUG-Users] MySQL

Robert Wolfe rwolfe at fpsoft.net
Wed Feb 1 22:07:36 EST 2012


Yep, I saw that an fixed that to the IP of my MySQL server and now it
works.

 

From: users-bounces at wnylug.org [mailto:users-bounces at wnylug.org] On
Behalf Of Monkberry
Sent: Wednesday, February 01, 2012 9:00 PM
To: Western New York Linux Users Group Users Mailing List
Subject: Re: [WNYLUG-Users] MySQL

 

This inside of my.cnf should have been a huge clue ;-)


# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1


On 02/01/2012 06:46 PM, Robert Wolfe wrote: 

Actually, I just had to have it listed on the 192.168.75.x IP vs the
127.0.0.1 IP and it's working like charm now.

 

From: users-bounces at wnylug.org [mailto:users-bounces at wnylug.org] On
Behalf Of Tyler Poland
Sent: Wednesday, February 01, 2012 6:34 PM
To: Western New York Linux Users Group Users Mailing List
Subject: Re: [WNYLUG-Users] MySQL

 

Named pipes are Windows only. Your default config is probably not
enabling tcp and local connections are relying on a socket file. In the
config comment out 'skip-networking' and add 'bind-address =...' with a
valid IP for the MySQL box (preferably internal). Restart the database
when complete.

Try connecting from the remote host with the mySQL (my phone keeps force
capitalizing that :/ ) client. Assuming the configuration is correct you
should get a database response. If there are issues with the user or
password they'll be more visible this way.

Thank you,
Tyler
sent from my Droid Bionic

On Feb 1, 2012 6:09 PM, "Robert Wolfe" <rwolfe at fpsoft.net> wrote:

I think that it has more to do with the fact that, as someone put it
earlier, it's running using named pipes vs network connectivity.  I will
change that configuration sometime today (gotta love VPNs *smiles*).

 

From: users-bounces at wnylug.org [mailto:users-bounces at wnylug.org] On
Behalf Of Christopher Hawkins
Sent: Wednesday, February 01, 2012 5:36 PM
To: users at wnylug.org
Subject: Re: [WNYLUG-Users] MySQL

 

Assuming mysql default port 3306 is open and not firewalled, you should
only need a user with the right access permissions. Something like this
will create the user and grant access:

GRANT USAGE ON *.* TO 'someuser'@'%' IDENTIFIED BY 'somepassword';
GRANT ALL PRIVILEGES ON my_wp_database.* TO 'someuser'@'%';
flush privileges;

Does that help?

On 2/1/2012 5:19 PM, Robert Wolfe wrote: 

Hi all!

 

Here is the deal.  I have an Apache server set up in a VM running Debian
and a MySQL server setup running on another one.  However, whenever I go
to set up Wordpress to access the database on the SQL server, I get a
message saying that a connection to the database cannot be made.  I am
at a loss at this point as to what more I need to do to get this to
work, so any pointers would be greatly appreciated.






_______________________________________________
 
 
Users mailing list
Users at wnylug.org
http://wnylug.org/mailman/listinfo/users_wnylug.org


_______________________________________________
Users mailing list
Users at wnylug.org
http://wnylug.org/mailman/listinfo/users_wnylug.org

 
 
_______________________________________________
Users mailing list
Users at wnylug.org
http://wnylug.org/mailman/listinfo/users_wnylug.org

 

-- 
 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://wnylug.org/pipermail/users_wnylug.org/attachments/20120201/8b5823a9/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 17606 bytes
Desc: image001.png
URL: <http://wnylug.org/pipermail/users_wnylug.org/attachments/20120201/8b5823a9/attachment-0001.png>


More information about the Users mailing list