Help needed for configuring MySQL on Mac OSX
-
I’m running Mac OSX Leopard and am havingtroubles configuring MySQL to work with PHPMyAdmin.
I enabled Apache and PHP from Within Mac OSX. Then Installed MySQl from a package on their website. Downloaded PHP myadmin and unzipped it to localhost/phpmyadmin.
Problem is that I can’t login as Root via phpmyadmin. I can log in using the username: mysql and no password. But that account does not have access to anything. As far as I know there shouldn’t be a password for the root account so I don’t know what the problem is.
I have tried the following which is where I am now:
Kasper-MAC:bin kasper$ sudo /usr/local/mysql/bin/mysql -u root Password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 21 Server version: 5.1.32 MySQL Community Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> update user set password=("12345") where User='root'; ERROR 1046 (3D000): No database selected mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> update user set password=("12345") where User='root'; Query OK, 3 rows affected (0.00 sec) Rows matched: 3 Changed: 3 Warnings: 0 mysql>
After taht I tried again to login via phpmyadmin with password ‘12345’ but get the message:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
I have no problem logging in as: mysql and just leaving password empty. But I need a user that have privileges to create and change databases.
- The topic ‘Help needed for configuring MySQL on Mac OSX’ is closed to new replies.