Databases Special Interest Group
From Admin-SIG
| Table of contents |
Welcome to the NMOSUG SIG-Databases Wiki
Perpetually under construction, as all good wikis are.
This is the wiki for the New Mexico Open Source User Group Databases Special Interest Group. It is a community resource, a place to find some answers, and a place to share your knowledge and experience with others. Much as we love open source software, documentation is a weak spot. Actually, it is a weak spot with products of all kinds. Today what we see is more and better documentation produced by users, or peers. Wiki's are one of the mechanisms being used to that end.
This only works if people participate, lots of people, so please, feel free to create [http://www.nmosug.org/admin-wiki/index.php/Special:Newpages new articles]. Heck, feel obligated to create new articles ;-) It's easy. Here's how. (http://www.nmosug.org/adminwiki/index.php/Main_Page/add_article)
Fedora Core 5 MySQL 5.0 Install
Fedora 5 RedHat Install
1/2G of RAM on Pentium 3 - 700MH
Allow 1-2 hours
Install Tips
I removed all partitions and started with a clean pc manually entered a hostname set root password
note - On both SUSE and Red Hat default MySQL installs do not use the standard directory structure in the MySQL documentation
Check Office Productivity Box
Check Webserver Box
Then do a custom install
Under Applications/Graphical Internet add thunderbird
Under Ofice Productivity add Open Ofice BASE(component of Open Office)
Under Development add eclipse add ruby
Under Servers / MySQL add all optional packages
Under Server Config Tools Add windows file server
Under Base System / System Tools add RDesktop - remote connection add tsclient
/usr/bin - is where the mysql executables are located
MySQL needs a 'mysql' database to run properly
mysql is administered by root
/usr/bin/mysql_install_db --user=root
Start the MySQL Server
/usr/bin/mysqld_safe --user=root &
Verify that the server is running and works properly
/usr/bin/mysqladmin version
Connect to MySQL Server
/usr/bin/mysql -u root
show databases;
Set the root Password (use SQL command)
select host, user from mysql.user; Delete from mysql.user where user = ; flush privileges; select host, user from mysql.user;
look for the record that has root in the user column and something other than localhost in the host column - this is the host_name. remember that this is the Mysql superuser
set password for 'root'@'localhost' = password ('new_password');
set password for 'root'@'host_name' = password ('new_password');
Now you can - quit
Restart the server
/usr/bin/mysqladmin -u root -p shutdown /usr/bin/mysqld_safe --user=root &
Connect to MySQL Server
/usr/bin/mysql -u root -p --- noticed that you had to supply a password exit
A few commands from terminal
mysqlshow -p mysqlshow -p mysql mysqladmin -p variables
Admin Tool MySQL Administrator
Download MySQL Administrator from MySQL (rpm format - suse has it's own) run the download it loads the executable into /usr/bin cd /usr/bin and execute mysql-administrator &
Admin Tool PhpMyAdmin - Web Based Tol
this is web based so remember to start apache apachectl start if you wish to stop - apachectl stop
Download PhpMyAdmin from phpmyadmin.net or sourceforge put in /var/www/html/ you will need a config.inc.php gunzip tar -xvf
| MySQL | PostgreSQL | ANTDB |
Please see documentation on customizing the interface (http://meta.wikipedia.org/wiki/MediaWiki_i18n) and the User's Guide (http://meta.wikipedia.org/wiki/MediaWiki_User%27s_Guide) for usage and configuration help.
