MySQL - Access denied for user?

[brucerowe]

I have just reformatted a new hard drive and installed the latest Linux Mint 17(Rebecca) on my 32 bit machine. The colors are gorgeous and I love the speed that it responds. However, I cannot seem to login to MySQL (MariaDB).

MySQL has been restarted with /etc/init.d/mysql restart and is running. I give the command to log in the first time:
mysql -u root -p
I press enter and I get a response:
ERROR 1045 (28000): Access denied for user 'root'@'localhost'

I am familiar with Linux and MySQL. I have uninstalled and re-installed MySQL. I have set up many other MySQL installations on Linux (though never on Mint or Ubuntu). There was never any problem like this.

Does anyone know what is going on here? Does anyone know what do do about it?

[DataMan]

You referenced MariaDB in your post. I understand it's close to MySQL but not the same. Did it afford you an opportunity to establish the root account when it was built initially?

-DataMan
-who has not built a MariaDB server ... yet.

[brucerowe]

MariaDB is pretty much the same as MySQL. It was built and maintained by the same team that built MySQL. When Oracle bought MySQL, a lot of people worried that Oracle would kill MySQL. MySQL competes with the commercial product. Given Oracle's adventures suing Google over the use of Java, this was not unfounded.

MariaDB is the replacement for MySQL in Red Hat and Mint. My own experience is that MariaDB also works well.

The first time I installed Maria, it installed when I re-formatted the drive and installed Mint. I did not have a chance to put in a root password. When I uninstalled and re-installed the database (with the Synaptic Package Manager), I did not have the opportunity either.

So, the database is running. I just cannot log in and start using it.

bruce@bruce-Vostro-230 ~ $ ps ax | grep mysql
1365 ? S 0:00 /bin/bash /usr/bin/mysqld_safe
1366 ? S 0:00 logger -p daemon.err -t /etc/init.d/mysql -i
1729 ? Sl 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
3174 pts/0 S+ 0:00 grep --colour=auto mysql

[DataMan]

Found this:

https://mariadb.com/blog/how-reset-root ... iadb-linux

Hopefully this will get you up and running.


-DataMan

[brucerowe]

IT WORKED! Those instructions were just what I needed.

Thanks again for your help.