MySql - tut

linux~

1) Start after a fresh install:

#> mysql -u root

2) Set the password for first time:

From inside SQL:

mysql> set password for 'root'@'localhost' = password ('test')

From outside SQL:

#> mysqladmin -u root password test1

3) If password is set, to change password:

#> mysqladmin -u root -ptest1 password test2

4) See if mysql is running:

#> ps -ef | grep mysqld

5) Starting and Stopping mySQL:

Starting:

#> ./etc/init.d/mysql start

Stop:

#> ./usr/bin/mysqladmin -u root -p shutdown

6) Adding a user to Mysql Db

mysql> use mysql;

mysql> insert into user (host, user, password, select_priv, insert_priv, update_priv) values ('localhost', 'guest', password('guest123'), 'Y', 'Y', 'Y');

mysql>flush privileges;

mysql> select host, user, password from user where user = 'guest';

7) creating a database call tutorials:

mysql> create database tutorials

8) view values in the table

SELECT * FROM table_name

1 Week Rinux ( Linux ) Challenge

So... you know, i do the windows and linux thing alot. Well offically ive put down windows crack addiction finally, and have VM'd it for school but thats it pretty much. Which you know this was coming once i go a serious unix/linux job, and as some of you may not know.. I DID! no more support coordination! I am a Linux Administrator now! Woot Woot!

So my wise idea was hell lets kick over to that Centos 5.0 update 2 install i have going on. *LOL* let me tell you, if you like ease of use, kids stick with Ubuntu... Centos is a night mare I've had to add repo's for almost everything i want to install. I have a botched version of VLC going on, botch version of almost everything, and if its not botched its bastardized to the max!

So heres my set up...

Centos5 - Vmwared out w/ Debian 4.0rc4/Ubuntu 8.04/Winxp SP3

Additional fun stuff:

So I thought I would add some essential links:

http://www.sklav.com/?q=node/2

Best noted resources here are: All the Rpm repo's

http://sabarish4u.wordpress.com/2008/07/14/install-vlc-videolan-on-centos-system/

Best noted resources here are: Yum Repo's & good practice

http://www.highonsolder.org/2007/11/play-sirius-internet-radio-on-linux.html

Best noted resources here are: Sirius installation on linux

http://www.fsdaily.com/

Best noted resources here are: OpenSource news and Howto's

http://www.ubuntugeek.com/

Best noted resources here are: Howto's for Ubuntu

http://www.cyberciti.biz/

Best noted resources here are: All around & Howto's

http://www.fosswire.com

Best noted resources here are: All around, Community News & Howto's