mysql setup issue
Wade Smart
wadesmart at gmail.com
Thu Aug 23 20:15:18 UTC 2018
I installed mysql on my new system (18.04). Ive followed the
steps to install but at no point have I been able to access mysql
to set the password. Im run into one of two errors:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
or
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
when following this:
Set mysql root password
Before accessing the database by console you need to type:
$ mysql -u root
At the mysql console type:
$ mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');
After a few hours I removed mysql server completely, rebooted,
installed and had the
same problem. I cant figure a way around setting the initial password.
The instructions
to reset a forgotten root pw say:
Stop the mysql demon process using this command :
sudo /etc/init.d/mysql stop
Start the mysqld demon process using the --skip-grant-tables option
with this command
sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &
$ sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &
$ [1] 5799
mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)
[1]+ Exit 1 sudo /usr/sbin/mysqld
--skip-grant-tables --skip-networking
What to do next?
Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
More information about the ubuntu-users
mailing list