Dear List,
I have installed a binary package mysql-5.0.51a-osx10.5-x86_64.dmg
I can start up/shutdown MySQL and connect to MySQL server, but I cant
change a root password as required.
-------begin example-------
e7253:~ olichka$ cd /usr/local/mysql
e7253:mysql olichka$ sudo ./bin/mysqld_safe
Password:
Starting mysqld daemon with databases from
/usr/local/mysql-5.0.51a-osx10.5-x86_64/data
^Z
[1]+ Stopped sudo ./bin/mysqld_safe
e7253:mysql olichka$ bg
[1]+ sudo ./bin/mysqld_safe &
e7253:mysql olichka$ /usr/local/mysql/bin/mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.51a MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> set password for 'root'@'localhost'=password('password');
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
-------end example---------
I can verify that server is running:
-------begin example------------
e7253:mysql olichka$ bin/mysqladmin version
bin/mysqladmin Ver 8.41 Distrib 5.0.51a, for apple-darwin9.0.0b5 on i686
Copyright (C) 2000-2006 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.51a
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 4 min 41 sec
Threads: 1 Questions: 4 Slow queries: 0 Opens: 12 Flush tables: 1
Open tables: 6 Queries per second avg: 0.014
------end example-----------
And I can shutdown the server:
------begin example---------
e7253:mysql olichka$ bin/mysqladmin -u root shutdown
e7253:mysql olichka$ STOPPING server from pid file
/usr/local/mysql-5.0.51a-osx10.5-x86_64/data/e7253.mb.qub.ac.uk.pid 080421
14:57:13 mysqld ended
-----end example------------
Some tests:
-----begin example----------
e7253:mysql olichka$ bin/mysqlshow
+--------------------+
| Databases |
+--------------------+
| information_schema |
| test |
+--------------------+
------end example-----------
As I understand, when I use a binary package I dont have to initialize the
grant tables manually (i.e. mysql_install_db). Hovever as I see above I
dont have a mysql db where all granted tables would be installed? I would
expect installer to run 'mysql_install_db' for me or not?
When I try to log in as a root, so I can change passwords:
I get:
------begin example----------
e7253:/ olichka$ mysql -u root
-bash: mysql: command not found
-----end example------------
Sorry for my ignorance, most probably I am doing something wrong, but I am
very new to both MySQL and UNIX.
Could you please suggest anything?
Thank you in advance,
Olga
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
