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;
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
Post a Comment