Tech-Today
I. Installation
In your terminal execute the following commands:
You should be prompted to set your password.
Try myql -u root -p, if it does not work we need to configure the root user.
II. Configuration
Go back to your terminal and execute the following commands:
Exit mysql and connect without using sudo.
In case something goes wrong. Here's how you can uninstall MariaDB
Open
- How To Install Mysql In Ubuntu 16.04
The following commands allow us to install a MySQL server on Ubuntu 16.04, create a database, user and table. And finally, tune the server. # install mysql sudo apt-get update sudo apt-get upgrade sudo apt-get install mysql-server sudo mysql_secure_installation...
- Install Jenkins On Ubuntu
wget -q -O - https://pkg.jenkins.io/debian-stable/jenkins.io.key | sudo apt-key add - Then add the following entry in your /etc/apt/sources.list: deb https://pkg.jenkins.io/debian-stable binary/ sudo apt-get update sudo apt-get install jenkins sudo usermod...
- How To Use Mariadb And Liquibase Together With Maven On Jboss
First you must define the needed dependency in your pom file. <profile> <id>mariadb</id> <activation> <property> <name>env</name> <value>mariadb</value> </property> </activation> <properties>...
- How To Install Apache2 Php5 And Mysql5 In Ubuntu 12.04
These are the set of scripts I executed in ubuntu to install the ff: 1.) apache2 2.) php5 3.) mysql5 >sudo apt-get install apache2 //installs in /etc/apache2 >sudo apt-get install php5 //installs in /etc/php5 >sudo apt-get install libapache2-mod-php5...
- How To Start/stop An Application On Boot On Ubuntu Like Services.msc In Windows
There's an easy way now to configure what application runs on ubuntu's startup like services.msc in windows. Rather than adding/modify some configuration, we can install a simple GUI that can do the job. sudo apt-get update sudo apt-get install...
Tech-Today
Install and Configure MariaDB on Ubuntu
I. Installation
In your terminal execute the following commands:
sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64] http://mirror.zol.co.zw/mariadb/repo/10.3/ubuntu bionic main'
sudo apt update
sudo apt -y install mariadb-server mariadb-client
You should be prompted to set your password.
Try myql -u root -p, if it does not work we need to configure the root user.
II. Configuration
Go back to your terminal and execute the following commands:
sudo mysql -u root
SELECT User,Host FROM mysql.user; # notice that root is assigned to localhost not %
DROP USER 'root'@'localhost';
CREATE USER 'root'@'%' IDENTIFIED BY 'secret';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
Exit mysql and connect without using sudo.
In case something goes wrong. Here's how you can uninstall MariaDB
apt-get remove --purge mariadb-server mariadb-client
sudo apt-get autoremove
sudo apt-get autoclean
sudo apt-get install mariadb-server mariadb-client
sudo apt-get --purge remove "mysql*"
sudo rm -rf /etc/mysql
Open
/etc/apt/sources.list and remove all instances of MariaDB.Then finally run sudo apt update.
- How To Install Mysql In Ubuntu 16.04
The following commands allow us to install a MySQL server on Ubuntu 16.04, create a database, user and table. And finally, tune the server. # install mysql sudo apt-get update sudo apt-get upgrade sudo apt-get install mysql-server sudo mysql_secure_installation...
- Install Jenkins On Ubuntu
wget -q -O - https://pkg.jenkins.io/debian-stable/jenkins.io.key | sudo apt-key add - Then add the following entry in your /etc/apt/sources.list: deb https://pkg.jenkins.io/debian-stable binary/ sudo apt-get update sudo apt-get install jenkins sudo usermod...
- How To Use Mariadb And Liquibase Together With Maven On Jboss
First you must define the needed dependency in your pom file. <profile> <id>mariadb</id> <activation> <property> <name>env</name> <value>mariadb</value> </property> </activation> <properties>...
- How To Install Apache2 Php5 And Mysql5 In Ubuntu 12.04
These are the set of scripts I executed in ubuntu to install the ff: 1.) apache2 2.) php5 3.) mysql5 >sudo apt-get install apache2 //installs in /etc/apache2 >sudo apt-get install php5 //installs in /etc/php5 >sudo apt-get install libapache2-mod-php5...
- How To Start/stop An Application On Boot On Ubuntu Like Services.msc In Windows
There's an easy way now to configure what application runs on ubuntu's startup like services.msc in windows. Rather than adding/modify some configuration, we can install a simple GUI that can do the job. sudo apt-get update sudo apt-get install...