MySQL Magic

Monday, December 22, 2008

How to login with the mysql user: sudo bin/mysqld_safe --user=mysql --log &
Shutdown mysql server: bin/mysqladmin -u root shutdown
switch to root user: bin/mysql -u root
initialize context for a database: USE databasename or mysql -h host -u user -p dbname

MySQL Commands

Create A Table
CREATE TABLE `joetest`.`User` (
`id` INT( 255 ) NOT NULL AUTO_INCREMENT,
`user_name` VARCHAR( 20 ) NOT NULL ,
`password` VARCHAR( 20 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = INNODB

Labels: Technology