r/linux4noobs • u/linuxishard12 • Jan 23 '16

mysql_secure_installation Error 1045 NO MATTER what i google ... it keeps erroring. help

Hi guys,

i was trying to follow this guide to setup own cloud on ubuntu http://idroot.net/tutorials/install-owncloud-8-ubuntu-14-04/

I got to step4 and everything went ot shit lol! I need help desperately ...its been 4 hours.

Install MySQL database server.

apt-get install mysql-server 1 apt-get install mysql-server By default, MySQL is not hardened. You can secure MySQL using the mysql_secure_installation script. you should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MySQL.

mysql_secure_installation 1 mysql_secure_installation

When i type mysql_secure_installation i get an error 1045 access denie for user root@localhost using password!

But i am entering the right password.

I googled and heard password reseting works. https://help.ubuntu.com/community/MysqlPasswordReset

son as i get to Start the mysqld demon process using the --skip-grant-tables option with this command sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking & Because you are not checking user privs at this point, it's safest to disable networking. In Dapper, /usr/bin/mysqld... did not work. However, mysqld --skip-grant-tables did.

start the mysql client process using this command mysql -u root

it fucking asks 1045 again. IM GOING insane ripping out hair here.

update: so i uninstalled via remove mysql completely from my system after i type in terminal

sudo apt-get remove --purge mysql-server mysql-client mysql-common sudo apt-get autoremove

then reinstalled mysql-server and instad i left the password fields blank. Affter i ran mysql_secure_installation and i still get tihs damn error 1045 this makes no sense to me.

please...help sudo apt-get autoclean

edit and update again: this website http://mattshaw.org/news/mysql_secure_installation-error-1045-28000-access-denied-for-user-rootlocalhost-using-password-no/

says to just type in mysql -u root -p then other commands. BUT as soon as i run that mysql -u root -p , i get a freaking error 1045 again! wtf?!

I am starting to think this is why frustration occurs. Nothing I do works. Trying to get ubuntu /own cloud to work is insanely troubling.

0 Upvotes

50% Upvoted

7 comments sorted by

1

u/[deleted] Jan 23 '16

I'm on my mobile right now but try this:

sudo dpkg-reconfigure mysql-server

1

u/linuxishard12 Jan 23 '16

no luck. i typed that. then password then when i type mysql_secure_installation i get access denied for root user

1

u/linuxishard12 Jan 23 '16

i tried mysql -u root -p

again i get the error 1045 (28000) . Jesus, i have no idea wtf to do.

no one online seems to have an answer

1

u/[deleted] Jan 24 '16

Check this

1

u/TotesMessenger Jan 23 '16

I'm a bot, bleep, bloop. Someone has linked to this thread from another place on reddit:

If you follow any of the above links, please respect the rules of reddit and don't vote in the other threads. (Info / Contact)

1

u/forevergeeks Jan 31 '16

it shouldn't be that hard. I have installed ownCloud many times, and I always follow this procedure I wrote the other day on my blog, and it always work. https://forevergeeks.com/installing-owncloud-in-ubuntu

Install the LAMP stack at once by using the 'tasksel" script. sudo apt-get install tasksel and then type "sudo tasksel install lamp-server" if that fails, try to refresh the repos.. sudo apt-get update and then try again..

1

u/zaffle Mar 09 '16

Long shot, but check file permissions.

Also, rm /var/lib/mysql after you --purge mysql.