{"id":2781,"date":"2022-12-03T19:49:56","date_gmt":"2022-12-04T03:49:56","guid":{"rendered":"https:\/\/doubleecpu.com\/?page_id=2781"},"modified":"2022-12-03T19:49:56","modified_gmt":"2022-12-04T03:49:56","slug":"install-mariadb-and-php-my-admin","status":"publish","type":"page","link":"https:\/\/doubleecpu.com\/index.php\/install-mariadb-and-php-my-admin\/","title":{"rendered":"Install MariaDB and PHP My Admin"},"content":{"rendered":"\n

MariaDB <\/h2>\n\n\n\n

To install the database engine use the following command<\/p>\n\n\n\n

sudo apt-get install mariadb-server php-mysql -y\nsudo service apache2 restart <\/pre>\n\n\n\n
PHPMyAdmin <\/h2>\n\n\n\n
Add PHPMyAdmin installation packet manager<\/p>\n\n\n\n
 sudo apt install phpmyadmin <\/pre>\n\n\n\n
 Select Apache Setup for LAMP Server<\/p>\n\n\n\n
\"Select<\/figure>\n\n\n\n
 Then configure database<\/p>\n\n\n\n
\"Then<\/figure>\n\n\n\n
Create password <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n

then setup database 
Enter MySQL ‘root’ level password <\/p>\n\n\n\n
sudo mysql -u root 
[MariaDB] use mysql; 
[MariaDB] update user set plugin='' where User='root'; 
[MariaDB] flush privileges; 
[MariaDB] \\q 
#This needs to be followed by the following command: mysql_secure_installation <\/pre>\n\n\n\n
Delete the default mysql root user and create a new mysql root user,  for use by the webserver and php scripts. <\/p>\n\n\n\n
You will be asked Enter current password for root (enter for none): \u2014 press Enter.
Type in Y and press Enter to Set root password?.
Type in a password at the New password: prompt, and press Enter. Important: remember this root password, as you will need it later to set up WordPress.
Remove anonymous users. Y
Disallow root login remotely. Y
Remove test database and access to it. Y
Reload privilege tables now. Y
#The message will appear:
All done!  Thanks for using MariaDB!.<\/p>\n\n\n\n
Web server will be connected to PHP and MySQL
Test PHP server at  url : http:\/\/127.0.0.1\/phpmyadmin<\/code> 
login user: root Password: entered in previous steps
If there is no connection to PHP then move phpmyadmin config file<\/p>\n\n\n\n
cd \/etc\/apache2\/conf-available
sudo ln -s ..\/..\/phpmyadmin\/apache.conf phpmyadmin.conf
cd \/etc\/apache2\/conf-enabled
sudo ln -s ..\/conf-available\/phpmyadmin.conf phpmyadmin.conf
sudo service apache2 restart<\/pre>\n","protected":false},"excerpt":{"rendered":"
MariaDB To install the database engine use the following command sudo apt-get install mariadb-server php-mysql -y sudo service apache2 restart PHPMyAdmin Add PHPMyAdmin installation packet manager sudo apt install phpmyadmin Select Apache Setup for LAMP Server Then configure database Create password then setup database Enter MySQL ‘root’ level password sudo mysql -u root [MariaDB] use … <\/p>\n
Read more “Install MariaDB and PHP My Admin”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2781","page","type-page","status-publish","hentry"],"featured_media_urls":[],"_links":{"self":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages\/2781","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/comments?post=2781"}],"version-history":[{"count":1,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages\/2781\/revisions"}],"predecessor-version":[{"id":2783,"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/pages\/2781\/revisions\/2783"}],"wp:attachment":[{"href":"https:\/\/doubleecpu.com\/index.php\/wp-json\/wp\/v2\/media?parent=2781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}