unable to change root password on Mac OSX 10.5.2

2008-04-21 Thread Olga Lyashevska
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

Re: unable to change root password on Mac OSX 10.5.2

2008-04-21 Thread Warren Young
Olga Lyashevska wrote: e7253:mysql olichka$ /usr/local/mysql/bin/mysql Try: $ /usr/local/mysql/bin/mysql -u root -p It looks like you aren't logging into MySQL as root, so you don't have permission to set the root password. (If you don't give -u, it uses your OS X short user name

Re: unable to change root password on Mac OSX 10.5.2

2008-04-21 Thread Olga Lyashevska
Dear List, I have solved my problem I think. For some reasons 'alias mysql=/usr/local/mysql/bin/mysql' didnt work for me. When I type '/usr/local/mysql/bin/mysql -u root' I can log in as a root and change password. Later I can log in: '/usr/local/mysql/bin/mysql -u root -p' Thank you, Olga