NETWORKSTIP Networking CCNA,Centos,Ubuntu,Sql,

Made By Muhammad Nafees

Breaking

Showing posts with label MariaDB. Show all posts
Showing posts with label MariaDB. Show all posts

Wednesday, 5 December 2018

December 05, 2018

Completely remove MariaDB or MySQL from CentOS 7 or RHEL 7

Completely remove MariaDB or MySQL from CentOS 7 or RHEL 7

 

  •  sudo yum remove -y mariadb mariadb-server && sudo rm -rf /var/lib/mysql /etc/my.cnf
If Above Command does not work

  • yum remove mariadb mariadb-server
  • rm -rf /var/lib/mysql
  • rm /etc/my.cnf
  • yum install mariadb mariadb-serve
  • yum remove MariaDB-server MariaDB-client
  • sudo systemctl stop mysqld.service && sudo yum remove -y mariadb mariadb-server && sudo rm -rf /var/lib/mysql /etc/my.cnf
  • rpm -qa | grep mariadb
  • rpm -e --nodeps "mariadb-libs-5.5.56-2.el7.x86_64"
  • rpm -e --nodeps "mariadb-server-5.5.56-2.el7.x86_64"
  • rpm -e --nodeps "mariadb-5.5.56-2.el7.x86_64"
  • rm -f /var/log/mariadb
  • rm -f /var/log/mariadb/mariadb.log.rpmsave
  • rm -rf /var/lib/mysql
  • rm -rf /usr/lib64/mysql
  • rm -rf /usr/share/mysql
1
- 1 comment:
Labels: , , ,

Monday, 19 December 2016

How To Reset A Forgotten Root Password For MariaDB On CentOS 7
December 19, 2016

How To Reset A Forgotten Root Password For MariaDB On CentOS 7

How To Reset A Forgotten Root Password For MariaDB On CentOS 7

Lost your MariaDB root password? Well, you’re in luck because this brief tutorial is going to show you how get into the database server and create a new root password.
When you forget the root password for MariaDB database server, you can’t just unlock or recover it, you must create a new and different one. To do this you need root privileges on the server you’re running MariaDB database server on. Then you need to use a backdoor trick that most people use to the reset forgotten root password for MySQL or MariaDB database server.
So, if you’ve forgotten your password to sign on MariaDB server, continue below.
This first thing you need to do is stop the database server. Obviously your site will be down, but this is the only way to access the backdoor of the server to reset the password. To stop or shutdown MariaDB on CentOS 7, run the commands below.
sudo systemctl stop mariadb.service

On Ubuntu run the commands below
sudo service mariadb stop

Next, you need to start MariaDB with unrestricted access so you wouldn’t need password to sign on as the root user. This starts the database server in an insecure manner keeping it wide open to anyone.
Because the database is left wide open, you should safeguard against someone logging into the database remotely. This could happen, so add the –skip-networking option to the commands.
sudo mysqld_safe --skip-grant-tables --skip-networking &

Now that the database is started, you can now logon to it without passwords. Run the commands below to sign on to the database without prompting for password.
mysql -u root

Once you’re logged-on, change to the mysql database. This database comes with all MySQL and MariaDB servers. It’s store encrypted credentials and privileges for the root user.
To change to the mysql database, run the commands below.
use mysql;

Next, run the commands below to change the root password
update user set password=PASSWORD("new-password") where User='root';
Remember to replace new-password with the root password and press Enter.
Then run the commands below to flush or reset the privileges table.
flush privileges;
Exit.

Now that the root password is changed, you should now be able to stop/start MariaDB server normally and and logon as the root user using the new password you created above.
You can stop, then start the server using the commands below
To stop the database, run the commands below.
sudo systemctl stop mariadb.service
To start, run the commands below
sudo systemctl start mariadb.service

Then logon as the root user with the new password using the commands below. W
mysql -u root -p

That’s it!  This is how you reset or re-created forgotten root password for MariaDB database server.
0
- No comments:
Labels: , , ,

Saturday, 10 September 2016

September 10, 2016

MariaDB on CentOS 7 commands and functions

MariaDB on CentOS 7


Enable MariaDB to start on boot and then start the service:
  1. sudo systemctl enable mariadb
  2. sudo systemctl start mariadb

Harden MariaDB Server

  1. Run the mysql_secure_installation script to address several security concerns in a default MariaDB installation:
  2. sudo mysql_secure_installation

Root Login

  1. To log in to MariaDB as the root user:
  2. mysql -u root -p

Create a New MariaDB User and Database

In the example below, testdb is the name of the database, testuser is the user, and passwordis the user’s password:

  1. create database testdb;
  2.  create user 'testuser'@localhost identified by 'password';
  3.  grant all on testdb.* to 'testuser' identified by 'password';
You can shorten this process by creating the user while assigning database permissions:
  1. create database testdb;
  2.  grant all on testdb.* to 'testuser' identified by 'password';
View the new Databases:
  1. show databases;
    View the new table:
    1. show tables;
    To retrieve all Users in MariaDB, you can execute the following SQL statement:
    1. SELECT User FROM mysql.user;

    Reset the MariaDB Root Password

    If you forget your root MariaDB password, it can be reset.
    1. Stop the current MariaDB server instance, then restart it with an option to not ask for a password:
    2. sudo systemctl stop mariadb
    3. sudo mysqld_safe --skip-grant-tables &
    Reconnect to the MariaDB server with the MariaDB root account:
    1. mysql -u root
    Use the following commands to reset root’s password. Replace password with a strong password:

    1. use mysql;
    2. update user SET PASSWORD=PASSWORD("password") WHERE USER='root';
    3. flush privileges;
    4. exit
    Then restart MariaDB:
    1. sudo systemctl start mariadb
    However, note that this query shows a large listing of MySQL user information, including user permission information, so as a practical matter you may want to trim down some of the fields to display, something like this:
    1. mysql> select host, user, password from mysql.user;
    The next section provides details and background information about this second query.

    How to reduce the amount of ‘user’ information shown

    You can get a listing of the fields in the mysql.user table by running this MySQL query:
    1. mysql> desc mysql.user;
    So for most cases where you want to show MySQL user accounts you'll probably want to limit your MySQL users' query to a few important columns, something like this:
    1. select host, user, password from mysql.user;
    0
    - No comments:
    Labels: , , , ,