Fedora Linux Support Community & Resources Center
  #1  
Old 27th September 2007, 06:28 PM
prudhviy Offline
Registered User
 
Join Date: Apr 2007
Location: vijayavada,india
Age: 24
Posts: 17
mysql-connection problem

i hav written a php script which has a mysql connection...
but it is giving the message cannot connect
intially selinux prevented it.....
then when i tried this command
#mysql --user=root --password=***** --host=ipaddress
it is giving the message...
ERROR 1130 (00000): Host '172.16.119.22' is not allowed to connect to this MySQL server
help me plzzzz
regards
Reply With Quote
  #2  
Old 27th September 2007, 06:36 PM
brunson Offline
Registered User
 
Join Date: Jun 2005
Location: Westminster, Colorado
Posts: 2,304
If it's running on the same box, then don't specify --host, and it will make a local socket connection. If it is not running on the same host, or you need to use a network transport even though you're local for some reason, then issue this command:
Code:
grant all on *.* to root@'172.16.119.22' identified by 'yourpassword';
If you need to do grants via your application:
Code:
grant all on *.* to root@'172.16.119.22' identified by 'yourpassword' with grant option;
__________________
Registered Linux User #4837
411th in line to get sued by Micro$oft
Quote:
Basically, to learn Unix you learn to understand and apply a small set of key ideas and achieve expertise by expanding both the set of ideas and your ability to apply them - Paul Murphy
Reply With Quote
Reply

Tags
mysqlconnection, problem

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
C++ and MySQL connection: Is it possible? tech291083 Programming & Packaging 4 27th March 2007 03:32 AM
FC4, Tomcat5, MySql and connection problem.... Kalimdor Using Fedora 2 19th July 2006 09:45 AM


Current GMT-time: 11:28 (Friday, 24-05-2013)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat