Make sure you are logging in as indicated in the docs.
Something along these lines (from local host)
shell> mysql -u username -p hostname databasename
if hostname (being your hosts domain name) doesn't work
try "localhost"
It may be possible that mysql needs to be owned over to
a user id on the server and run as that ID.
What I typically do is after compile and install of the
mysqld, I do this.
adduser mysql
cd /usr/local/mysql-version
chown -R mysql.mysql *
./bin/mysqld_safe --user=mysql &
In order to perform these tasks you may need to stop the
mysqld daemon with
killall -9 mysqld
(may need to enter it a couple of times it tends to try to restart.
I usually use the up arrow to scroll back commands, and kill it several
times)
Hope this helps you.
Note that the error message you sent me is errorno 13.
shell>perror 13
Permissions are not correct or are denied.
This is why I make these recommendations.
Kelly W. Black
Irvine Ca.
sql , query
-----Original Message-----
From: CM Miller [mailto:cmmiller1973@stripped]
Sent: Thursday, October 31, 2002 5:11 PM
To: mysql@stripped
Subject: Still not getting a mysql prompt
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.p
i
>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.p
i
>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.p
i
>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.p
i
>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
---------------------------------------------------------------------
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 <mysql-thread123738@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-kblack05=sprintspectrum.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
