/ Postinstallation setup /// cd /usr/local/mysql / End of source-build specific instructions /// DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DWITH_BOOST=/home/down/boost_1_77_0 SELECT User, Host, Password FROM mysql.I am installing MySQL using a standard source distribution, here are the steps I am following during the installation: mkdir /home/downĬmake. In case you want to view all users that currently exist If you want to view all the databases in MariaDb

Some useful commands that might come in handy In the above command replace MarxDBxyz with your database name, Marx1234z with the username you prefer and enter a strong password in place of password123Īll done, now type quit and hit enter to exit the database management system. Grant all privileges on MarxDBxyz.* to identified by ‘password123’

With the help of the command below a new user will be created, a password will be given to that and also the user will be granted all the privileges which would allow it to function normally. So I created a database with the name MarxDBxyz and now its time to assign a user to the database. Replace database_Name with the name you want to give to your database. Now enter the following to create a database You will be asked to enter the password it is the same password which you set previously during the mysql_secure_installation

So either keep it in your mind or save the details in a secure place to be used later.įirst login into the database management system using the command below Now its time to create a new database and a user, you need to remember the database name, username and password because it is going to be used later on when you install wordpress. You have successfully removed the insecure defaults and secured the database management system. Reload privilege table now ? – input y for this as well. Remove test database and access to it ? – enter y RDBMS is up and running now lets secure it by removing some of the defaults.ĭo not type anything just press enter and then you will be asked to set root password for mariadb.Īfter setting the root password you will be asked a bunch of questions.ĭisallow root login remotely ? – enter y (yes)

Mariadb install centos 7