Reinstalling Lubuntu after a frustrating morning.
" ... made sure I set the root password."
I cannot seem to set a root password. I don't get prompted while installing MySql or MariaDB, I don't get a mysqld.log to grep for a temporary password, the mysql_secure_database (or whatever it is called) says it has set the root password, but won't let me use it to log in, if I start MySQL in safe mode and disabling the grant tables, I can't log in to change the password. MythTV-setup won't connect to the database.
It is driving me nuts. I thought I'd be done by now. My old server is starting to make noises and I want to change to a new machine, but ... maybe just go buy a commercial PVR and be done with it.
If *I* cannot find the MySQL root password, how does the mythtv set up script create the database????
[SOLVED] How On Earth Do You Get It Working?
Moderator: Forum Moderators
-
- Newcomer
- Posts: 8
- Joined: Mon Aug 31, 2015 10:45 pm
-
- Senior
- Posts: 265
- Joined: Sun Jun 15, 2014 1:08 am
Re: [SOLVED] How On Earth Do You Get It Working?
Don't need root password.. maybe you do to set GRANTs though, don't recall.
You can find debian-sys-maint user's password & can (re)set the client username & password in /etc/mysql/debian.cnf
then connect as required user.
mysql -hHost -uUsername -p mythconverg
or root user:
sudo mysql<enter>
<sudo_pwd>
or may find your normal user password works.. does here.
mysql -uroot -p<enter>
"user_pwd"
You can find debian-sys-maint user's password & can (re)set the client username & password in /etc/mysql/debian.cnf
then connect as required user.
mysql -hHost -uUsername -p mythconverg
or root user:
sudo mysql<enter>
<sudo_pwd>
or may find your normal user password works.. does here.
mysql -uroot -p<enter>
"user_pwd"