
I have installed MySQL on Ubuntu but have not initialised anything yet. I want to learn it well enough to set up a simple database for my audio collection and also a simple database for work. Neither will be on-line or need high security. What is the easiest way to initialise it? Do you just run the install script (as root?) shell> cd mysql_installation_directory shell> ./scripts/mysql_install_db shell> ./bin/safe_mysqld --user=mysql & or shell> ./bin/mysqld_safe --user=mysql & if you are running MySQL 4.x. and continuing? I want to set it up for user rod to be able to experiment easily without ruining everything. Also what and tutorial GUI would you reccommend for my purposes? I see the python front-end was also installed along with MySQL and I have installed mysqlcc. Any pointers greatly appreciated Roderick Aldridge