List:General Discussion« Previous MessageNext Message »
From:Kelly W [PCS] Black Date:November 1 2002 2:16am
Subject:RE: Still not getting a mysql prompt
View as plain text  
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
Thread
Still not getting a mysql promptCM Miller1 Nov
  • RE: Still not getting a mysql promptDaevid Vincent1 Nov
RE: Still not getting a mysql promptKelly W [PCS] Black1 Nov
  • RE: Still not getting a mysql promptJennifer Goodie1 Nov
  • Re: Still not getting a mysql promptMark1 Nov
RE: Still not getting a mysql promptKelly W [PCS] Black1 Nov