Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [root]

16 questions
3
votes
2 answers

Unable to run mariadb in safe mode

When I run following command mysqld_safe --skip-grant-tables & I get message myuser@myvm:~$ 200523 08:24:41 mysqld_safe Logging to syslog. 200523 08:24:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql After that when I type…
Frank Martin
  • 451
  • 1
  • 5
  • 18
1
vote
0 answers

Changing root and user passwords in MariaDB 10.5?

We have a few MariaDB servers (MariaDB 10.5, running on Debian 11/bullseye) where we need to change the passwords for the DB root user and for other user accounts in the DB system (by which I mean users in MariaDB itself, not Linux account…
dave559
  • 121
  • 1
  • 6
1
vote
1 answer

Backing-up Postgresql data when only root login is available (Ubuntu)

I have a Ubuntu-based workstation with several boot issues that prevent any user login - only logging in as "root" works. Before formatting the Ubuntu partition to perform a clean installation, I wanted to backup the users' Postgresql database…
Louis15
  • 113
  • 3
1
vote
1 answer

Lost admin user ; Update not allowed on current user in MySQL

I work on MySQL. For making my database more secure I created new user and than deleted 'root' user which had all privileges. I think I did not give full privileges to new user. That's why it is giving error whenever I try to update a table in…
Danish
  • 11
  • 1
1
vote
1 answer

MariaDB root password change using Ansible

I had tried to change MariaDB root password using following Ansible script. - name: Dump MySQL root Password debug: msg: "MySQL new Password : {{ mysql_pass }}" - name: Set MySQL root Password become: True …
Sachith Muhandiram
  • 111
  • 5
1
vote
1 answer

Should I revoke login from the default pgsql user?

I set up a localhost pgsql installation (os x catalina, homebrew, 12.*). I am developing a sql data warehouse and I’d like my dev environment to be as close to the production one as possible. Homebrew created a default superuser, chris. Is it ok…
Chris
  • 185
  • 1
  • 3
  • 7
0
votes
2 answers

Unable to Add New Database in CloudPanel VPS - Access denied for user 'root'@'localhost'

Problem I'm facing an issue with my VPS running CloudPanel where I cannot add new databases due to MySQL root access being denied. Environment CloudPanel on VPS MySQL Server Hosting Provider: Hostinger Error Message Access denied for user…
Joe
  • 1
0
votes
0 answers

MySQL: Reconnect to Existing Database that I lost access to

Note I am not a programmer by trade. I have the most annoying problem ever while using MySQL 8.0, and all online resources I've seen provide zero solutions. I have one of those MySQL data directories that contains folder names such as…
ZZ Top
  • 1
  • 1
0
votes
1 answer

Reset root password in MySQL

I am logging in with root user in MySQL, and the server has been hardened, so this parameter is set default-authentication-plugin=caching_sha2_password, and this is currently the only user I have. getting the following error: ERROR 1820 (HY000): You…
datascinalyst
  • 105
  • 2
  • 11
0
votes
1 answer

MySQL denied me access after changing my password

I am new to MySQL. Today is my first day using it through XAMPP. I have managed to change my password using the code mysqladmin -u root password Suddenly I was denied access from XAMPP and from the MySQL Admin portal. I tried to reset the password…
Learner123
0
votes
1 answer

problem installing mariadb using mysql_secure_installation

I started secure install of MySQL with sudo mysql_secure_installation command, and I got that message: Securing the MySQL server deployment. Enter password for user root: Error: Can't connect to local MySQL server through socket…
Orestas Nastulevicius
  • 1
  • 2
0
votes
3 answers

Supplying root password to MySQL V8 sort of fails

On Ubuntu 20.04 I have installed MySQL V8.0.25. But I kind of fail to apply a (valid) root password. The apt-get process for installing mysql-server did not ask for a root password. And I cannot enter mysql with the "mysql -u roor -p" command, I…
Ulrich
  • 101
  • 2
0
votes
1 answer

How to change user privileges from 'Y' to 'N' in MySQL Server?

I want to change a privilege to my glpiuser from 'N' to 'Y'. In MySQL server, what is the command to do this task? Here's the image that display my users. I'm using Ubuntu 20.04.1
Taoufik Mourtadi
0
votes
1 answer

Do I have to worry that root user can login into MariaDB 10.5 without password

I remember when installing MySQL Server 8.0, or in some database setups, there are warnings about no password login. Should I worry about this? I think if someone gets access to root user on my debian they can reset root password of MariaDB. What is…
Ehsan88
  • 101
  • 2
0
votes
0 answers

Deleted MySQL “root” user in phpMyAdmin through XAMPP local host…how to restore?

I was working in phpMyAdmin (XAMPP localhost) to add a user for a new database I created for a local WordPress website, and came upon the list of users named "root". Since I did not remember ever creating these root users, I tried to delete them. I…
TWyPGn
  • 1
  • 1
1
2