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
