Re: Ubuntu MySQL install with Virtualmin - password problems with 16.04.4 server

On 29/03/2018 16:36, The Natural Philosopher wrote:
> On 29/03/18 15:51, Abandoned Trolley wrote:
>> On 29/03/2018 14:01, J.O. Aho wrote:
>>> On 03/29/18 11:38, Abandoned Trolley wrote:
>>>> hi there,
>>>>
>>>> Is there anybody out there having problems with the MySQL root password
>>>> when MySQL installion is carried out by Virtualmin.
>>>
>>> No, don't use it.
>>>
>>>
>>>> I am using the latest Virtualmin install script, and a fresh clean
>>>> install of the latest 16.04.4 server distro but I still keep getting
>>>> locked out.
>>>>
>>>> Any suggestions ?
>>>
>>> https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
>>>
>>>
>>
>> I was hoping to get a response from somebody who actually uses Virtualmin
>>
> I have used it (well webmin) in the past, but never to install mysql
>
> Can you acess mysql at all on the host? Can you get a console session?
>
> Can you set up phpmydamin? I find that is a pretty good interface to
> mysql at least to start with
>
> Its a bit open to hacking for long term use unless you take precautions
>
>
>
>> AT
>>
>> ---
>> This email has been checked for viruses by AVG.
>> http://www.avg.com
>>
>
>

[Quoted] [Quoted] I am able to get in to mysql by simply using "mysql --user=root" as superuser on the machine console - so there is not problem getting access to the database.

[Quoted] I don't understand how it is that I can assign a root password as part of the Virtualmin install, which Virtualmin then uses to administer the database - but I cannot use that same password to log in, even at the console.

AT Received on Thu Mar 29 2018 - 20:09:41 CEST