MySQL Notes

PATH=$PATH:/c/Program\ Files/MySQL/bin; export PATH
        

To log in as the mySQL administrator do (by default 'root' has no password):

mysql -h localhost -u root
        

mysql> set password for root@localhost=PASSWORD('new_password');
        

or from a shell prompt run:

mysqladmin -u root password new_password
        

mysql -h localhost -u username -p (you'll be prompted for the password)

mysql -h localhost -u username -p[password] (no space before password)

mysql -h localhost -u username -p[password] [db_name]
        

mysql> select version(), current_date;
        

This displays the name of the user that is currently logged in.

mysql> select user(), current_date;
        

mysql> select host, user from mysql.user;
        

mysql> show databases;
        

mysql> use [db_name]
        

Note that no semi-colon is needed at the end of the statement.

mysql> create database dbName;
        

mysql> show tables;
        

mysql> describe [table_name];
        

mysql> grant all privileges
    -> on dbName.*
    -> to username@localhost
    -> identified by 'password';

mysql> flush privileges;
        

mysql> show grants for userid;
        

mysql -h localhost -u username -p dbName
        

or

mysql -h localhost -u username -ppassword dbName
        

To run a SQL script from the command line:

mysql -h localhost -u platform -p dbName < CreateAllTables.mysql.sql
        

Modify c:\my.ini (or my.cnf). According to the MySQL documentation, the solution to this problem is to add the following line to your \Windows\my.ini file:

innodb_data_file_path = ibdata1:20M:autoextend 
        

mysql -u root -ppassword
use mysql
delete from User where User = "";