CocoaMySQL

Excel -> csv file. BBEdit -> txt file, unix format. Import Text File … Fields terminated by ‘,’ and lines by ‘\n’ (LF).

Up and running

CocoaMySQL

Yee-hah.

MySQL on MacBook: #5

desdevlin:/usr/local/mysql desdevlin$ mysql –user=root mysql -p
Enter password:

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. [etc ...]

mysql> GRANT ALL PRIVILEGES ON *.* TO ‘desdevlin’@'localhost’ IDENTIFIED BY ’some_password’ WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> 

MySQL on MacBook: #4

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

To do so, start the server, then issue the following commands:

./bin/mysqladmin -u root password ‘new-password’

./bin/mysqladmin -u root -h desdevlin.local password ‘new-password’

MySQL on MacBook: #3

cd /usr/local/mysql/ 

sudo ./configure 

MySQL on MacBook: #2

desdevlin:~ desdevlin$ mysql

ERROR 1045 (28000): Access denied for user ‘desdevlin’@'localhost’ (using password: NO) 

MySQL on MacBook: #1

echo ’export PATH=/usr/local/mysql/bin:$PATH’ >> ~/.bash_profile

Log out 

Installing MySQL 5.0 on MacBook

In plain text because of the STUPID WordPress editor …

http://dev.mysql.com

http://www.entropy.ch

http://cocoamysql.sourceforge.net/

Reinstalled MySQL

sudo rm /usr/local/mysql* Reinstalled 5.0.41. Here are some details …

mysqladmin -u root -p create droop;mysql -u rootmysql> grant create,insert,delete,update,select on droop.* to droop@localhost; Query OK, 0 rows affected (0.03 sec) mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE    ->   TEMPORARY TABLES, LOCK TABLES    ->   ON droop.*    ->   TO 'droop'@'localhost' IDENTIFIED BY '';Query OK, 0 rows affected (0.00 sec) http://g4.local/drupal/http://g4.local/drupal/?q=user/register droop/root@localhost droop/*********

More MySQL

Got Drupal up and running after cracking the db installation.MySQL 6 does not run on pre-Tiger OSX. Had to go back to 5. More details to come.