Проект «SnakeProject» Михаила Козлова

⇒ FreeBSD and Nix ⇐

CISCO

Voice(Asterisk\Cisco)

Microsoft

Powershell

Python

SQL\T-SQL

1С

Общая

WEB Разработка

ORACLE SQL \ JAVA

Мото

FreeBSD + MySQL

FreeBSD + MySQL

#Предварительно

pkg install gcc

mkdir -p /data/mysql

#Установка MySQL

cd /usr/ports/databases/mysql56-server
make install clean

cd /usr/ports/databases/mysql56-client
make install clean

rehash

echo 'mysql_enable="YES"' >> /etc/rc.conf
echo 'mysql_dbdir="/data/mysql"' >> /etc/rc.conf

cp /usr/local/share/mysql/my-small.cnf /var/db/mysql/my.cnf

/var/db/mysql/my.cnf:
... [mysqld] port = 3306 bind-address = 127.0.0.1 socket = /tmp/mysql.sock log_error = /var/log/mysql/mysql.err ...

cp -R /var/db/mysql /data

chown -R mysql:mysql /data/mysql

mkdir /var/log/mysql
touch /var/log/mysql/mysql.err
chown -R mysql:mysql /var/log/mysql

/usr/local/etc/rc.d/mysql-server start
ps ax | grep mysql
sockstat -4 | grep 3306
/usr/local/etc/rc.d/mysql-server status

rm -rf /var/db/mysql

mysql_secure_installation
#(или mysqladmin -u root password 'New_root_pass')

mysql -uroot -p show databases; select @@datadir; CREATE USER 'mysqluser'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'mysqluser'@'localhost' WITH GRANT OPTION; \q

GRANT ALL PRIVILEGES ON:
*.* - databases_names*tables_names 'mysqluser'@'localhost - user@ip ('localhost', 'ip адрес' или '%')

Комментарии пользователей