• kasperbs

    (@kasperbs)


    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.

Viewing 1 replies (of 1 total)
  • I us a package called MAMP on my Mac and login to MySQL using phpMyAdmin with these (default) settings

    Host: localhost
    [Port: 8889]
    User: root
    Password: root

    Hope it helps

    John

Viewing 1 replies (of 1 total)
  • The topic ‘Help needed for configuring MySQL on Mac OSX’ is closed to new replies.