If you are a beginner and are using red hat why don't use the mysql rpms. It does everything for you.
When you compile php, be sure you have the right path for mysql (I think that is your error in this case). Finally, be sure you entered the user right for the connection, with the host specified. On Monday 10 December 2001 07:04 am, you wrote: > I knew that would get your attention. But it may become reality because I > don't seem to have the skill to solve this problem as I'm a Linux novice > and my Win2K install works perfect. It would be a shame to give up on > Linux in favor of Microsoft but it works on Microsoft. > > I have run out of ideas and need some help. I'm now well into my 4th day > working on this problem and letting you know that I have done my research > before posting and wasting your time hashing over ideas that have already > been posted. > > I've tried implementing all the solutions outlined throughout this site and > nothing works yet. I'm running RedHat 7.1. I installed the latest release > of MySQL and have run every test in the manuals, the readme's and the > conversation threads. > > Everything works perfectly. > > When I try to connect with "either" MySQLGUI or PHP I get the error: > Can't connect to local MySQL server though socket " (111) > > I telnet in and it tells me that MySQL is running > MySQL shows up in my active processes so it is definately running > I can manage the database from MySQLAdmin > I've ensured that the mysql.sock exists in var/lib/mysql. > I've created the link in the /tmp/ folder. > I've updated the my.cnf file > I've reset all permissions on those files to chmod 777 > I've allowed group "nobody" in permission to database directory and files > as well as my.cfg and both mysql.sock files (in tmp and var/lib) > I've tried setting my.cfg, and mysql.sock permissions in various > configurations including user:mysql and group:mysql and made sure that > apache user was a member of group mysql and vice versa. > I also used chmod 777 on both (although I'm not exactly sure I used it > correctly). > I also modified the PHP ini file although I also can't connect from > MySQLGUI and I don't believe it uses PHP (it looks like Java, but I can't > be sure). Just in case I tried the PHP.ini file anyway. No luck. > etc. etc. etc... > > As I stated, the MySQL is running and everything tests fine from > MySQLAdmin. > > Yes, I checked the socket entry and tried both /tmp/mysql.sock as well as > /var/lib/mysql/mysql.sock (both exist so I thought I'de try both). Since > most threaded conversations on this board deal with this issue I have spent > most of my time here. > > But I really starting to think this is a permissions problem but I'm not > good enough on Linux to figure it out. I think Apache can't get access to > the socket or mysql.optons file. I can't even get MySQLGUI to connect yet > everything works from MySQLAdmin without any problems. > > I'm targeting the permissions just because both MySQLGUI and PHP fail. > When I connect with the MySQLGUI client is first gives me the "can't > connect to 111" error. > Then if I choose "options" and change "localhost" to 127.0.0.1" and add > "mysql" in the default database, it then tells me that I don't have > permissions to change "/root/.mysqlgui/mysql.options". > Then when I try to connect and it requests my password, it then tell me > "Apache does not have permission to access the MySQL database". > > I don't see any of these problems from PHP, I actually get absolutely no > response at all. I can't even get a failure on "die" for a failed > connection attempt. > > Anyone run into permission problems before? > > Any help would be appreciated > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
