MySQLAndPHP
From LaurasWiki
NoteToSelf: Edit, archive
I've still got just a glancing knowledge of MySQL and PHP -- enough to skate through a MovableType install 2 years ago and, 2 months ago, WordPress and MediaWiki. Now I'm installing Tasks (http://www.alexking.org/software/tasks/) on my PowerBook and it's a little more demanding. So, here we go...
- laurazWiki on restarting MySQL on Valiant (http://www.netvironments.org/laurazWiki/SysAdminInfo) (RedHat Linux 9)
- Marc Liyanage's MySQL tutorial (http://www.entropy.ch/software/macosx/mysql/) : Helpful but stops short of what I need: creating a database
- Tasks: Database Settings (http://www.alexking.org/software/tasks/documentation/database.html) : Cryptic!
- MySQL Reference Manual ToC (http://dev.mysql.com/doc/mysql/en/index.html) : No, no, please (too much info)
[edit]
reinitializing database
I give up. Following instructions on Marc Liyanage's tutorial to make a clean start. Here's what that spit out, maybe it will be useful:
thilion:/usr/local/mysql latrippi$ sudo find /usr/local/mysql/data -type f -exec rm {} ';'
Password: [thilion admin password]
thilion:/usr/local/mysql latrippi$ sudo hostname 127.0.0.1
thilion:/usr/local/mysql latrippi$ cd /usr/local/mysql
thilion:/usr/local/mysql latrippi$ sudo ./scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
050804 0:40:24 Warning: Setting lower_case_table_names=2 because file system for /usr/local/mysql-standard-4.0.25-apple-darwin6.8-powerpc/./data/ is case insensitive
050804 0:40:25 ./bin/mysqld: Shutdown Complete
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
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 127.0.0.1 password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe
