Practice makes perfect Practice makes perfect

MySQL

• mysql workbench in Debian 6.0

  Computer/linux 2010. 2. 24. 12:08

  * download source from http://dev.mysql.com/downloads/workbench/5.2.html * tar zvxf mysql-workbench-oss-5.2.16.tar.gz * ln -s mysql-workbench-oss-5.2.16 mysql-workbench * Install the following package (information from INSTALL file) [] sudo apt-get install build-essential autoconf automake libtool libzip-dev libxml2-dev libsigc++-2.0-dev libglade2-dev libgtkmm-2.4-dev libglu1-mesa-dev libmysqlcl..

  Read More

• MySQL commands

  Computer/linux 2010. 2. 17. 23:53

  MySQL ROOT # access MySQL root account to mysql itself [] mysql -u root -p mysql # Show GRANT mysql> show grants; mysql> show grants for 'user'; mysql> show grants for 'user'@'localhost'; myslq> show grants for user@localhost; # Set priv_type (GRANT) types of priv ALTER Modify tables with ALTER TABLE CREATE Make new database, table, or index DELETE Remove rows from tables DROP Remove databases o..

  Read More