[slimshady023]

Hi Everyone,

I am attempting to follow the instructions for setting up MySQL on Panther (as described on entropy.ch).

I have followed the instructions precisely, and it appears that everything is functioning. However, when I attempt to login to 'localhost' using my username and password, I am denied access. I can login to 'localhost' without a username and password just fine, but am then unable to create new databases because of insufficient permissions.

I have tried a number of things, including a root user (superuser) from the NetInfo Manager, and attempting to use that root username and password for the MySQL database. That is among other things, including a re-install, all of them being unsuccessful. If anyone has any suggestions, that would be awesome. Thanks!

- M

[philzilla]

it usually goes along these lines, and we'll say your password is "jarvis": [php]# start the server up
cd /usr/local/mysql
sudo echo
sudo ./bin/mysqld_safe &

#test you've got game
test

#you got game! so, quit it
quit

# set the admin password to "jarvis"
mysqladmin -u root password jarvis

# login to the mysql shell
mysql -h localhost -u root -p

# give the user the right permissions
GRANT ALL PRIVILEGES ON *.* TO mysql@localhost IDENTIFIED BY 'jarvis';

# see what databases are present
SHOW DATABASES;

# create a database
CREATE DATABASE slimshady;

# select the database for usage
USE slimshady;[/php] try that. if any of it fails, it's because it's almost 6am here, and i need sleep, bad

[madmacgames]

I have installed MySQL on OS X a number of times, and doing so, would highly recommend installing the Server Logistics package installer:
http://serverlogistics.com/mysql.php

It installs MySQL 4.0.15 for you and adds a nice preference pane to system preferences where you can set the MySQL root password, start and stop the MySQL server, and have it automatically start when the system does. OF coarse all this can be done from terminal command line, but hey, there is nothing like the OS X experience

I would also recommend CocoaMySQL to manage your MySQL databases:
http://cocoamysql.sourceforge.net/

phpMyAdmin is also very good for managing mySQL databases. I use both CocoaMySQL and phpMyAdmin. CocoaMySQL most of the time (I can't say it enough: nothing like the OS X experience) and occasionally phpMyAdmin when wanting to do something that either CocoaMySQL will not do or if I like how phpMyAdmin does it better.

[slimshady023]

Thanks to both of you for your help, but there must be something else going on with my system, because neither suggestion worked. I first attempted using the serverlogistics.com prefpane for creating the root username and password. Everything appeared as though it were running correctly, but the same insufficient privileges message came through when attempting to create a database. Eee...

I also tried reinstalling the entropy software from scratch, and using the your (Philzilla's) code. My cousin came by and we were both trying to crack this thing, but it isn't working, and it just doesn't make sense why it isn't.

I also tried installing the serverlogistics package, and following your instructions, but it too was responding with the same permission problems. I have been following all the instructions to the 't', so this is a pretty awesome challenge. I think it's about time to order a good MySQL book!

Thank you again for your suggestions, and late-night code writing!

- M

[si_lance]

you did try flushing the privileges right using mysqladmin?

http://www.mysql.com/doc/en/mysqladmin.html