Debian installation MySQL

Http://thirteen-tw.blogspot.com/2008/09/debian-mysql-server.html

• Installation Mysql-server
  
  debian:~# Apt-get Install Mysql-server
  
  
• Activate Mysql-server
  
  debian:~#/etc/init.d/mysql Start
  
  
• Client-side connection to Mysql-server
  
  The machine
  
  debian:~# Mysql-u Root-p
  
  Remote Terminal
  
  debian:~# mysql-h 140.134.210.131-u root-p
  
  
• Information Warehouse operation
  
  
  1. Connect to the client program in this machine
     
     debian:~# Mysql-u Root-p
     
     
  2. To inquire after the entry
     Mysql>show databases;
     Mysql>create database FCU;
     Mysql>show databases;
     
     
  3. Build Manager (Roor) remote account
     Mysql>grant all privileges on * * to [email protected] '% ' identified by ' something ' with GRANT OPTION;
     
     Identified by "Something" something password
     
     
  4. Increase W01 users can use the wdb rights of the repository
     
     Mysql>grant all privileges in wdb.* to [e-mail protected] identified by "1234"
     
     
  5. Refresh the Repository
     
     mysql> FLUSH privileges;
     
     
• Setting MY.CNF
  
  debian:~# vi/etc/mysql/my.cnf
  
  Fix
  
  #bind-address = 127.0.0.1
  
  
• Set MySQL password
  
  Msyql-u root-p
  Mysql>set password for [email protected] "%" =password (' rootpwd ');
  
  
• MySQL Language education Web site

Debian installation MySQL