Re: MySQL Installation Challenges
Chris Moy wrote: $mysqld_safe --user mysql & [EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from /var/lib/mysql 030812 13:24:04 mysqld ended but you can see that the deamon has "ended" right away. This should not happen, correct? look in the err-file. It's named laptop.err and lies in the data directory. /usr/local/mysql/data Did you enable innodb in /etc/my.cnf ? If yes, did you create it's data-folder ? Check if the user mysql can read/write there. * IMPORTANT * Don't use a file-manager like mc on the shell where you start mysql. It will look exactly like that if you run ./bin/mysqld_safe & from within mc though ./bin/mysqld_safe will work nut block the shell. Plain bash is fine. Then I go to connect to the server (locally) by entering in a mysqladmin command to check the version and the output is below: ... mysql ended error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' While we are at it. Some distributions put this socket elsewhere. SuSE has it's mysql package compiled to store data and socket in /var/lib/mysql. All client programs that came with the distribution will expect the stuff there. You have to symlink the socket to /var/lib/mysql to get the libraries working. Configured with: ../configure --prefix=/usr > '--bindir=/usr/bin' There you are ... RedHat's bin-directory is /usr/bin not /usr/local/mysql/bin '--datadir=/usr/share' and default data folder '--localstatedir=/var/lib/mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' and socket -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Installation Challenges
Chris Moy <[EMAIL PROTECTED]> wrote: >>Description: > > the installation procedure. I have installed the binaries as described > in the manual for installation and I am able to start mysql through > > $mysqld_safe --user mysql & > [EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from > /var/lib/mysql > 030812 13:24:04 mysqld ended > > but you can see that the deamon has "ended" right away. This should not > happen, correct? Look into error log file to see error message. > > Then I go to connect to the server (locally) by entering in a mysqladmin > command to check the version and the output is below: > > bin/mysqladmin: connect to server at 'localhost' failed > error: 'Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2)' > Check that mysqld is running and that the socket: '/tmp/mysql.sock' > exists! > > It does not seem like the deamon is running at all when I go to check > (ps -aux | grep mysql). Any ideas. I am a little new to MySql. > > Note: I have tried the latest version of MySQL and still get the same > problems but on a diff computer running the same OS (Linux RH 9.0)> > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]