I'm still not getting a mysql prompt to login to.
I've tried what was suggested below, but I'm not sure
what it does and I searched for that directory and
could not find a TMPDIR.
If I try loging in under Root or as a user by typing
mysql I get an error message: command not found, but
the mysql daemon is running.
Do I need to link some files from /usr/local/MySQL to
/bin?
Please help
thanks
-Chris
--- mysql-digest-help@stripped wrote:
>
> mysql Digest 31 Oct 2002 21:33:52 -0000 Issue 2159
>use this
>
>
>Shell>TMPDIR=/tmp
>Shell>export TMPDIR
>
>restart mysql.
>
>
>-----Original Message-----
>From: CM Miller [mailto:cmmiller1973@stripped]
>Sent: Thursday, October 31, 2002 9:42 AM
>To: mysql@stripped
>Subject: How do I log into MySQL?
>
>
>
>I can start/stop the daemon for MySQL with no
problem.
>
>And, if i ps -aux | grep mysql I show that it is
>running, but if I check the log I get the following
>output:
>
>021025 20:11:44 mysqld started
>021025 20:11:44
>/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/bin/mysqld:
>Can't create/write to file
>'/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/data/phoenix.miller.org.pi
>d'
>(Errcode: 13)
>021025 20:11:44
>/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/bin/mysqld:
>Can't find file: './mysql/host.frm' (errno: 13)
>021025 20:11:44
>/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/bin/mysqld:
>Error on delete of
>'/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/data/phoenix.miller.org.pi
>d'
>(Errcode: 13)
>021025 20:11:44 mysqld ended
>
>021025 20:14:17 mysqld started
>021025 20:14:17
>/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/bin/mysqld:
>Can't create/write to file
>'/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/data/phoenix.miller.org.pi
>d'
>(Errcode: 13)
>021025 20:14:17
>/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/bin/mysqld:
>Can't find file: './mysql/host.frm' (errno: 13)
>021025 20:14:17
>/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/bin/mysqld:
>Error on delete of
>'/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/data/phoenix.miller.org.pi
>d'
>(Errcode: 13)
>021025 20:14:17 mysqld ended
>
>
>
>I'm nost sure what to make of this, but is this the
>reason why I can't login?
>
>thanks
>
>-Chris
>
>
>
>=====
>*****************************************
>GAIM ID: cmmiller1973
>*****************************************
=====
*****************************************
GAIM ID: cmmiller1973
*****************************************
__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
=====
*****************************************
GAIM ID: cmmiller1973
*****************************************
__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com