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]



Reply via email to