mysql mariadb

sudo pacman -S mariadb
sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
#optional#sudo systemctl enable mariadb.service
sudo systemctl start mariadb.service
mysql_secure_installation

mysql -u root -p

CREATE USER 'username'@'localhost' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON mydb.* TO 'username'@'localhost';
FLUSH PRIVILEGES;


create database moo;
show databases;
use moo;
show tables;
create table animals( num int(2), name varchar(10), location varchar(10), primary key(num));
describe animals;
insert into animals ( num , name,location) values(1,'tiger','mountains');
select * from animals;
drop table animals;





Comments

Popular posts from this blog

[SOLVED] IDM WAS REGISTERED WITH A FAKE SERIAL NUMBER

The Twitter Followers Playbook

Hidden Wiki