Welcome Guest. Please Login or Register  
Client Area  |  Softaculous Cloud  |  Calendar  |  Quick Links  |  
   


You are here: Index > Webuzo > General Support > Topic : Fresh install; Trying to create 1st database; MYSQL ERROR: Access denied for user 'root'@'localhost'



Threaded Mode | Print  

 Fresh install; Trying to create 1st database; MYSQL ERROR: Access denied for user 'root'@'localhost' (3 Replies, Read 55766 times)
RagingBullDurham
Posted on # December 31, 2024, 9:01 pm
Group: Member
Post Group: Newbie
Posts: 7
Status:
Fresh Webuzo Install. Installed MariaDB. Uninstalled MySQL.

Went to Database wizard and
The following errors were found
  • MYSQL ERROR: Access denied for user 'root'@'localhost'
  • Unable to create database
Any suggestions?
IP: --   

Fresh install; Trying to create 1st database; MYSQL ERROR: Access denied for user 'root'@'localhost'
RagingBullDurham
Posted on # December 31, 2024, 9:13 pm | Post: 1
Group: Member
Post Group: Newbie
Posts: 7
Status:
I'm not logged in as root (i created a user/account, logged in as that user to get to the enduser panel, but the main control panel says "Logged in as root" at the top.
IP: --   

Fresh install; Trying to create 1st database; MYSQL ERROR: Access denied for user 'root'@'localhost'
RagingBullDurham
Posted on # December 31, 2024, 9:28 pm | Post: 2
Group: Member
Post Group: Newbie
Posts: 7
Status:
Finding the user is the issue.  When I log into webuzo as that end user name, webuzo thinks I am 'root'?

From command line (out side of Webuzo), I can successfully log into MariaDb

Code
[username ~] mysql -u <username>
Welcome to the MariaDB monitor. Commands end with ; or \g.MariaDB [(none)]>

but when I try the same thing as root...

Code
mysql -u root ERROR 1698 (28000): Access denied for user 'root'@'localhost'

How do I get webuzo use the username I used to create the account and STOP using root?
Does it have something to do that the username account is "Owned By: root", but I don't see a way to de-select?

IP: --   

Fresh install; Trying to create 1st database; MYSQL ERROR: Access denied for user 'root'@'localhost'
RagingBullDurham
Posted on # December 31, 2024, 11:42 pm | Post: 3
Group: Member
Post Group: Newbie
Posts: 7
Status:
SOLVED: I re-installed MariaDB (used the re-install button in the add apps section of the admin pages);  Then I restarted the service after install.
Thanks to everyone who took a look at this!
Does someone know how to marked this as RESOLVED?
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
7 guests, 0 users.


All times are GMT. The time now is March 26, 2025, 7:59 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.026