The Little Guy Posted July 24, 2007 Author Share Posted July 24, 2007 when I type in ps aux|grep mysqld, nothing happens, except a new blank line appears waiting for input. I can run phpmyadmin, and my website connects to the database fine too. character sets dir /data/mysql/esary/share/mysql/charsets/ basedir /data/mysql/esary/ datadir /dh/mysql/esary/data/ socket /tmp/mysql.esary.sock tmpdir /tmp/ Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-306597 Share on other sites More sharing options...
Wildbug Posted July 24, 2007 Share Posted July 24, 2007 when I type in ps aux|grep mysqld, nothing happens, except a new blank line appears waiting for input. From the shell prompt or the MySQL prompt? I meant run it in bash. But not matter.... I can run phpmyadmin, and my website connects to the database fine too. character sets dir /data/mysql/esary/share/mysql/charsets/ basedir /data/mysql/esary/ datadir /dh/mysql/esary/data/ socket /tmp/mysql.esary.sock tmpdir /tmp/ Try adding the --socket=/tmp/mysql.esary.sock to the mysql command. Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-306605 Share on other sites More sharing options...
The Little Guy Posted July 24, 2007 Author Share Posted July 24, 2007 Nope... That didn't work either /usr/bin/mysql publicsize --socket=/tmp/mysql.esary.sock --user=limited --password='rmn!!2233' < /home/ryannaddy/cron/logOut.sql /usr/bin/mysql --socket=/tmp/mysql.esary.sock publicsize --user=limited --password='rmn!!2233' < /home/ryannaddy/cron/logOut.sql Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-306671 Share on other sites More sharing options...
Wildbug Posted July 25, 2007 Share Posted July 25, 2007 Do you get a message? Do share. Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-307149 Share on other sites More sharing options...
The Little Guy Posted July 28, 2007 Author Share Posted July 28, 2007 Both say: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.esary.sock' (2) Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-309389 Share on other sites More sharing options...
The Little Guy Posted July 30, 2007 Author Share Posted July 30, 2007 Anything? Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-310682 Share on other sites More sharing options...
The Little Guy Posted July 31, 2007 Author Share Posted July 31, 2007 Anyone? Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-312144 Share on other sites More sharing options...
Wildbug Posted July 31, 2007 Share Posted July 31, 2007 You're going to have to find a way to connect to the MySQL server. If it's not running on your host (run "ps aux|grep mysqld" to verify), then you can't use a socket. I'm not sure how your ISP has things set up, so normal things might not work. How do you connect to MySQL in your PHP programs? You might try using the --host= option to connect if it's on a different host than localhost. Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-312155 Share on other sites More sharing options...
The Little Guy Posted August 1, 2007 Author Share Posted August 1, 2007 Got it! Final result: /usr/bin/mysql -hmysql.tzfiles.com publicsize --user=limited --password='rmn!!2233' < /home/ryannaddy/cron/logOut.sql Link to comment https://forums.phpfreaks.com/topic/61182-solved-run-sql/page/2/#findComment-312889 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.