> > you need to run > http://dev.mysql.com/doc/refman/5.0/en/mysql-secure-installation.html > (mysql_secure_installation) command from commandline Ok thanks, Ero! On Sun, Aug 31, 2014 at 7:06 AM, Eero Volotinen <eero.volotinen at iki.fi> wrote: > 2014-08-31 6:12 GMT+03:00 Tim Dunphy <bluethundr at gmail.com>: > > > Hello, > > > > I discovered today that CentOS 7 has replaced MySQL with MariaDB. Which > is > > fine, it's seems really similar. And I was already aware that it was > > written by the original team that wrote mysql. > > > > It's cool that the mysql command still gets you in! > > > > This is the version I have: > > > > [root at web1:~] #mysql --version > > mysql Ver 15.1 Distrib 5.5.37-MariaDB, for Linux (x86_64) using readline > > 5.1 > > > > But for some reason all I have to do is type the word 'mysql' to get me > > into the database. > > > > That's ok for initial setup I guess. But once I was in a did away with > all > > the accounts that either had blank set for the username, and updated all > > the accounts to use passwords. > > > > MariaDB [mysql]> select User,'@',Host,Password from user; > > +-------+---+-----------+-------------------------------------------+ > > > > | User | @ | Host | Password | > > > > +-------+---+-----------+-------------------------------------------+ > > > > | root | @ | localhost | *8328225AE4A663FAKEFAKEFAKEFAKEFAKE93D61 | > > > > | root | @ | web1 | *8328225AE4A663FAKEFAKEFAKEFAKEFAKE93D61 | > > > > | root | @ | 127.0.0.1 | *8328225AE4A663FAKEFAKEFAKEFAKEFAKE93D61 | > > > > | admin | @ | localhost | *8328225AE4A663FAKEFAKEFAKEFAKEFAKE93D61 | > > > > +-------+---+-----------+-------------------------------------------+ > > > > 4 rows in set (0.00 sec) > > > > I also did a search from root to find any my.cnf files and didn't find > any > > that has user accounts in them. > > > > Also I find that for the root accounts I can't seem to login even if I > set > > the password in the database without encryption and copy/paste the > password > > into the prompt. > > > > However the non-root account (admin) does let you in with the password. > > > > So I'm wondering how to secure mariadb so that it doesnt' let you in > > without typing in a username and password and also why it doesn't let you > > log in as 'root'? Is the root account disallowed from logging in by > > default? > > > > you need to run > http://dev.mysql.com/doc/refman/5.0/en/mysql-secure-installation.html > (mysql_secure_installation) command from commandline > > -- > Eero > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos > -- GPG me!! gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B