SH_GHAM wrote:How do i create username and password to log into mysql?
phpmyadmin, MySQL CLI, ... there are multiple ways to do so.
SH_GHAM wrote:I watched a video and said enter root for user name. and no password.
Which video?
SH_GHAM wrote:it did not work for me. i get an error message- entering to sql with out password is not allowed.
Is this a phpmyadmin error message?
Then you already have changed a few things, like changed the phpmyadmin setting
$cfg['Servers'][$i]['auth_type'] from config to something else like cookie or http.
You did change the default MariaDB port, Did you tell phpmyadmin to use the new port 3307?
What is the value of phpMyAdmin setting
$cfg['Servers'][$i]['AllowNoPassword']?
Did you set a password for user root@localhost?