MySQLAndPHP
From LaurasWiki
wyndham atlanta vinings hotel (http://santhoshck.com/files/images/comment-1589.htm) aconite (http://santhoshck.com/files/images/comment-1179.htm) r vicky video ygold (http://pbnf.org/engine/inc/files/topic-1203.html) toodyay stone (http://cj69collins.tv/blog/wp-content/uploads/2008/topic-141.html) job outlook (http://superamazingcomics.com/comics/thumbs/text662.htm) atlanta ga movie theatres (http://clode.com/guestbook/templates/css/2029.htm) patient home care (http://clode.com/guestbook/templates/css/1018.htm) shawn odonnell (http://superamazingcomics.com/comics/thumbs/text2712.htm) lipitor drugs (http://softcastle.com/cache/temp/topic-1231.htm) jackass the movie site myspace.com (http://a-wake.net/moodle/mdl174/users/3/article-1197.htm) 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)
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 &
You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests
Please report any problems with the ./bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
Yada yada -- that does look helpful!
thilion:/usr/local/mysql latrippi$ sudo chown -R mysql data/ Password: [thilion admin password] thilion:/usr/local/mysql latrippi$
Now, my command line prompt changed from 'thilion' to something numerical (127?) and freaked me out. But after rebooting, it seems fine.
