Questions tagged [root]
The root tag has no usage guidance.
14
questions
0
votes
1
answer
31
views
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.
...
0
votes
1
answer
85
views
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 ...
Learner123
1
vote
0
answers
221
views
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 ...
- 121
1
vote
1
answer
84
views
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 ...
- 113
0
votes
1
answer
1k
views
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 ...
0
votes
3
answers
583
views
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 ...
- 101
0
votes
1
answer
33
views
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
1
vote
1
answer
86
views
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 ...
- 11
1
vote
1
answer
1k
views
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 }}"
...
0
votes
1
answer
567
views
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 ...
- 101
0
votes
0
answers
46
views
Deleted MySQL “root” user in phpMyAdmin through XAMPP local host…how to restore? [duplicate]
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 ...
- 1
1
vote
1
answer
66
views
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 ...
- 183
2
votes
2
answers
2k
views
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 ...
- 441
0
votes
0
answers
610
views
Syntax error when update root password
I forgot MySQL root password so I am trying to change it by starting it in safe mode and running following command but getting syntax error. MySQL version is 8. What is the correct syntax to update ...
- 441