I just installed mysql 5.5.16 for snow leopard (via pkg install), but I have no permissions when running mysql (i.e. cannot grant privelages) and a lot of my commands are not recognized in shell/ bash (i.e. all of the 'mysql' co开发者_运维技巧mmands are not recognized).
I think I'm logged in as root, but when I do 'select user()', it shows that I'm signed is as 'btran' (not sure if this was created on accident, i just want to access to root and i'm not sure how to do that). Everything is on my local machine, just wanted to start learning mysql. I can provide more information, but any help will be greatly appreciated!
You didn't specify; what errors are you getting when you try the mysql commands? If the command can't be found then it's probably a path issue (A quick google search shows the mysql command is /usr/local/mysql/bin/mysql in snow leopard but I don't have a mac myself).
Second--just so we're clear--being root in the OS is not being root in MySQL. If the binaries are installed in the afore mentioned location, set your root password with the...
/usr/local/mysql/bin/mysqladmin -u root password [PASSWORD]
...command. Then login via...
/usr/local/mysql/bin/mysql -u root -p
EDIT: The path problem definitely seems right. Check out http://hivelogic.com/articles/compiling-mysql-on-snow-leopard/
精彩评论