Como isntalar o Mysql no Linux

Rode o comando abaixo para instalar

sudo apt-get install mysql-server

Durante a instalação você precisará fornecer a senha para o usuário root do Mysql. Rode o comando abaixo para acessar o shell do mysql

mysql -u root -p

Para testar, execute o comando que irá listar ...

How to install MySQL server 5.6 or 5.7 on Debian 7 and 8

  1. Download the MySQL APT repository config tool

wget http://dev.mysql.com/get/mysql-apt-config_0.7.3-1_all.deb

  1. Install the MySQL APT repository config tool

dpkg -i mysql-apt-config_0.7.3-1_all.deb

You will be asked to select product and version that you want to ...

Criar usuário e gerenciar permissões Mysql Linux

Primeiramente acesseo shell do mysql rodando o comando

mysql -u root -p

Agora rode o comando para criar um novo usuário, onde newuser e password são parametros

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

Agora, vamos dar os previlégios de acess ...

How to configure mysql for remote access via standard tcp

First of all, you have to edit mysql configuration file

nano /etc/mysql/my.cnf

So, you have to change bind-address key to droplet ip instead of 127.0.0.1 (Local Only)

bind-address = YOUR_DROPLET_IP

Restart Mysql Service to apply changes

**```sudo service mysql rest ...

Resolver problema do pdo_mysql php driver

sudo apt-get install php5-gd php5-mysql Once complete, you will need to restart the PHP service. Depending on how it was installed, you will need to do one of the following items:

If you installed it via LAMP (Linux Apache, MySQL, PHP5), then you'll need to restart the entire apache instan ...