apparently I can connect to mySQL, as a under privilege user,
but can't created a new database, after two days, of getting this far,
Now what?
So, I did the
[MacG4a:~] rnagle% mysql -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password:
NO)
[MacG4a:~] rnagle%
Which is suppose to be the ALL Mighty COMMAND to get in,
I even try to shutdown the server, (NO kill - 9 here !) can't
according the online manual,
Take down the mysqld server by sending a kill (not kill -9) to the
mysqld server. The pid is stored in a `.pid' file, which is normally in
the MySQL database directory:
shell> kill `cat /mysql-data-directory/hostname.pid`
did that, with
[MacG4a:~] rnagle% shell > kill `cat
/usr/local/mysql-3.23.53/data/MacG4a.local.pid'
Unmatched `.
[MacG4a:~] rnagle% shell > kill `cat
/usr/local/mysql-3.23.53/data/MacG4a.local..pid'
Unmatched `.
[MacG4a:~] rnagle%
[MacG4a:~] rnagle% shell > kill `cat
/mysql-data-directory/MacG4a.local.pid'
Unmatched `.
[MacG4a:~] rnagle%
[MacG4a:~] rnagle% mysqladmin shutdown
mysqladmin: shutdown failed; error: 'Access denied for user:
'@localhost' (Using password: NO)'
[MacG4a:~] rnagle%
[MacG4a:local/mysql/data] rnagle% pwd
/usr/local/mysql-3.23.53/data
[MacG4a:local/mysql/data] rnagle% ls -al
total 16
drwxr-x--- 6 mysql wheel 204 Dec 29 18:34 .
drwxr-xr-x 22 503 wheel 748 Nov 18 16:00 ..
-rw-r--r-- 1 mysql wheel 1700 Dec 29 18:34 MacG4a.local..err
-rw-rw---- 1 mysql wheel 3 Dec 29 18:34 MacG4a.local..pid
drwxr-x--- 20 mysql wheel 680 Nov 18 15:59 mysql
drwxr-x--- 2 mysql wheel 68 Nov 18 15:59 test
[MacG4a:local/mysql/data] rnagle%
--
Somewhere over the rainbow, the has to be a way to get access.
Anyone, ( was going to do a restart, with options:Restart mysqld with
the --skip-grant-tables option.
can't even get there.
Any Help would be appreciated, THANKS-!
Rick
---------------------------------------------------------------------
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
