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@;yahoo.com] Sent: Thursday, October 31, 2002 5:11 PM To: [EMAIL PROTECTED] 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 --- [EMAIL PROTECTED] 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@;yahoo.com] >Sent: Thursday, October 31, 2002 9:42 AM >To: [EMAIL PROTECTED] >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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php