20110825

mysql user with priviledges to his db

mysql> create database user_name DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
mysql> grant usage on *.* to user_name@localhost identified by 'user_pwd';
mysql> grant all privileges on user_name.* to user_name@localhost;

3 komentāri:

  1. JD2011. gada 25. novembris 04:14

    inline connecting: mysql -u user_name -ppassword database_name

    AtbildētDzēst
  2. JD2011. gada 25. novembris 04:22

    connect form outside: mysql -h ip_adress -u user_name -ppasword db_name

    AtbildētDzēst
  3. j.k.2011. gada 25. novembris 04:38

    mysqldump -h [hostname] -u [user] -p[password] [database_name] > [backupfile].dump

    mysql -h [hostname] -u [user] -p[password] [database_name] < [backupfile].dump

    AtbildētDzēst