mysql setup issue

Wade Smart wadesmart at gmail.com
Thu Aug 23 20:21:34 UTC 2018


I also tried this:

https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
-- 
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
On Thu, Aug 23, 2018 at 3:15 PM Wade Smart <wadesmart at gmail.com> wrote:
>
> 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