Page History
...
No Format |
---|
yum update yum install gcc yum install kernel-devel yum install bzip2 yum install kernel-devel-2.6.32-573.el6.i686 mkdir /media/cdrom mount /dev/scd0 /media/cdrom sh /media/cdrom/VBoxLinuxAdditions.run |
MYSQL
- 작동잘되는것 체크해서 되는놈 정리하기
...
...
mariadb(mysql db)
설치/시작
No Format |
---|
yum install mariadb
#서비스 시작은 설정완료후
service mariadb start
#root 비번설정
mysqladmin password
#부팅시 자동시작
systemctl enable mariadb.service
|
주요설정
No Format |
---|
/etc/my.cnf
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
auto-increment-increment = 100
auto-increment-offset = 1
|
계정 생성명령
No Format |
---|
create user 'user명'@'%' identified by '패스워드';
create user 'user명'@'localhost' identified by '패스워드';
flush privileges;
create database DB명;
grant all privileges on DB명.* to 'user명'@'%';
grant all privileges on DB명.* to 'user명'@'localhost';
|