mysqldump “Access denied” error on ubuntu with mariadb (login informations are correct) ...
Single author papers against my advisor's will?
Slither Like a Snake
Area of a 2D convex hull
Array/tabular for long multiplication
What do you call a plan that's an alternative plan in case your initial plan fails?
Classification of bundles, Postnikov towers, obstruction theory, local coefficients
Why is "Captain Marvel" translated as male in Portugal?
Passing functions in C++
Strange behaviour of Check
How do I automatically answer y in bash script?
Why use gamma over alpha radiation?
Geometric mean and geometric standard deviation
Simulating Exploding Dice
Antler Helmet: Can it work?
When communicating altitude with a '9' in it, should it be pronounced "nine hundred" or "niner hundred"?
Notation for two qubit composite product state
Autumning in love
How to rotate it perfectly?
How to market an anarchic city as a tourism spot to people living in civilized areas?
Is there folklore associating late breastfeeding with low intelligence and/or gullibility?
Replacing HDD with SSD; what about non-APFS/APFS?
Two different pronunciation of "понял"
Why is there no army of Iron-Mans in the MCU?
Fishing simulator
mysqldump “Access denied” error on ubuntu with mariadb (login informations are correct)
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)How do I set up Mysql Cluster?How can I get mysqldump to use the credentials from mysql_config_editor in a crontab-executed script?Why are MariaDB versions different with same configurations?MySQL Login ErrorUnable to access remotely (LAMP issue)Mariadb not working just after install on Ubuntu 16.04Cannot log into MySQLmysql restore from dump backup of all databases with user privilegesWith Adminer.php I get a Access denied for user 'root'@'localhost' error. Ubuntu 18.04mysqldump in 18.04 LTS
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I use Ubuntu with a mariadb database.
I want to make a mysqldump of my sql databases, but i get allways the following error:
mysqldump: Got error: 1045; "Access denied for user 'db_user-backups'@'localhosts' (using password: YES)" when trying to connect
The command that throws this error is following:
sudo mysqldump --defaults-file=/etc/mysql/my.cnf lom
I have allready added the username and passwort to /etc/mysql/my.cnf and made shure the cnf file has the right permissions:
[mysqldump]
user=db_user_backups
password=MyS3cretP4ssw0rD!
The username and password is correct, I can login with my sql client.
Does anyone have an idea whats im doing wrong?
(btw: please forgive me im a linux beginner ^^')
server mysql mariadb
asked Apr 12 '18 at 19:39
GoniosGonios
11
add a comment |
I use Ubuntu with a mariadb database.
I want to make a mysqldump of my sql databases, but i get allways the following error:
mysqldump: Got error: 1045; "Access denied for user 'db_user-backups'@'localhosts' (using password: YES)" when trying to connect
The command that throws this error is following:
sudo mysqldump --defaults-file=/etc/mysql/my.cnf lom
I have allready added the username and passwort to /etc/mysql/my.cnf and made shure the cnf file has the right permissions:
[mysqldump]
user=db_user_backups
password=MyS3cretP4ssw0rD!
The username and password is correct, I can login with my sql client.
Does anyone have an idea whats im doing wrong?
(btw: please forgive me im a linux beginner ^^')
server mysql mariadb
asked Apr 12 '18 at 19:39
GoniosGonios
11
add a comment |
I use Ubuntu with a mariadb database.
I want to make a mysqldump of my sql databases, but i get allways the following error:
mysqldump: Got error: 1045; "Access denied for user 'db_user-backups'@'localhosts' (using password: YES)" when trying to connect
The command that throws this error is following:
sudo mysqldump --defaults-file=/etc/mysql/my.cnf lom
I have allready added the username and passwort to /etc/mysql/my.cnf and made shure the cnf file has the right permissions:
[mysqldump]
user=db_user_backups
password=MyS3cretP4ssw0rD!
The username and password is correct, I can login with my sql client.
Does anyone have an idea whats im doing wrong?
(btw: please forgive me im a linux beginner ^^')
server mysql mariadb
asked Apr 12 '18 at 19:39
GoniosGonios
11
I use Ubuntu with a mariadb database.
I want to make a mysqldump of my sql databases, but i get allways the following error:
mysqldump: Got error: 1045; "Access denied for user 'db_user-backups'@'localhosts' (using password: YES)" when trying to connect
The command that throws this error is following:
sudo mysqldump --defaults-file=/etc/mysql/my.cnf lom
I have allready added the username and passwort to /etc/mysql/my.cnf and made shure the cnf file has the right permissions:
[mysqldump]
user=db_user_backups
password=MyS3cretP4ssw0rD!
The username and password is correct, I can login with my sql client.
Does anyone have an idea whats im doing wrong?
(btw: please forgive me im a linux beginner ^^')
server mysql mariadb
server mysql mariadb
asked Apr 12 '18 at 19:39
GoniosGonios
11
asked Apr 12 '18 at 19:39
GoniosGonios
11
asked Apr 12 '18 at 19:39
GoniosGonios
11
asked Apr 12 '18 at 19:39
GoniosGonios
11
asked Apr 12 '18 at 19:39
GoniosGonios
11
11
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
With error "Access denied for user 'db_user-backups'@'localhosts'. You can connect to db and grant permission for user 'db_user-backups' with command example:
Connect to Mysql: mysql -u root -p:
GRANT ALL PRIVILEGES ON *.* TO db_user-backups@'localhosts' IDENTIFIED BY 'password' with grant option;
flush privileges;
After you can reconnect with mysqldump.
answered Apr 19 '18 at 4:18
TannettoTannetto
40137
add a comment |
Try specifying the port. I'm using MySQL 8.0 on Windows but similar issues apply on Ubuntu. Without a port argument I got the same error:
C:Usersuser>mysqldump -u root -p airlines_test > C:...testairlines_test_dump.sql
Enter password: ******************
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
I fixed this by specifying the port to use: -P 3306:
C:Usersuser>mysqldump -u root -p -P 3306 airlines_test > C:...testairlines_test_dump.sql
Enter password: ******************
answered 14 mins ago
Karl BakerKarl Baker
1115
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1024456%2fmysqldump-access-denied-error-on-ubuntu-with-mariadb-login-informations-are-c%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
With error "Access denied for user 'db_user-backups'@'localhosts'. You can connect to db and grant permission for user 'db_user-backups' with command example:
Connect to Mysql: mysql -u root -p:
GRANT ALL PRIVILEGES ON *.* TO db_user-backups@'localhosts' IDENTIFIED BY 'password' with grant option;
flush privileges;
After you can reconnect with mysqldump.
answered Apr 19 '18 at 4:18
TannettoTannetto
40137
add a comment |
With error "Access denied for user 'db_user-backups'@'localhosts'. You can connect to db and grant permission for user 'db_user-backups' with command example:
Connect to Mysql: mysql -u root -p:
GRANT ALL PRIVILEGES ON *.* TO db_user-backups@'localhosts' IDENTIFIED BY 'password' with grant option;
flush privileges;
After you can reconnect with mysqldump.
answered Apr 19 '18 at 4:18
TannettoTannetto
40137
add a comment |
With error "Access denied for user 'db_user-backups'@'localhosts'. You can connect to db and grant permission for user 'db_user-backups' with command example:
Connect to Mysql: mysql -u root -p:
GRANT ALL PRIVILEGES ON *.* TO db_user-backups@'localhosts' IDENTIFIED BY 'password' with grant option;
flush privileges;
After you can reconnect with mysqldump.
answered Apr 19 '18 at 4:18
TannettoTannetto
40137
With error "Access denied for user 'db_user-backups'@'localhosts'. You can connect to db and grant permission for user 'db_user-backups' with command example:
Connect to Mysql: mysql -u root -p:
GRANT ALL PRIVILEGES ON *.* TO db_user-backups@'localhosts' IDENTIFIED BY 'password' with grant option;
flush privileges;
After you can reconnect with mysqldump.
answered Apr 19 '18 at 4:18
TannettoTannetto
40137
answered Apr 19 '18 at 4:18
TannettoTannetto
40137
answered Apr 19 '18 at 4:18
TannettoTannetto
40137
answered Apr 19 '18 at 4:18
TannettoTannetto
40137
40137
add a comment |
add a comment |
Try specifying the port. I'm using MySQL 8.0 on Windows but similar issues apply on Ubuntu. Without a port argument I got the same error:
C:Usersuser>mysqldump -u root -p airlines_test > C:...testairlines_test_dump.sql
Enter password: ******************
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
I fixed this by specifying the port to use: -P 3306:
C:Usersuser>mysqldump -u root -p -P 3306 airlines_test > C:...testairlines_test_dump.sql
Enter password: ******************
answered 14 mins ago
Karl BakerKarl Baker
1115
add a comment |
Try specifying the port. I'm using MySQL 8.0 on Windows but similar issues apply on Ubuntu. Without a port argument I got the same error:
C:Usersuser>mysqldump -u root -p airlines_test > C:...testairlines_test_dump.sql
Enter password: ******************
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
I fixed this by specifying the port to use: -P 3306:
C:Usersuser>mysqldump -u root -p -P 3306 airlines_test > C:...testairlines_test_dump.sql
Enter password: ******************
answered 14 mins ago
Karl BakerKarl Baker
1115
add a comment |
Try specifying the port. I'm using MySQL 8.0 on Windows but similar issues apply on Ubuntu. Without a port argument I got the same error:
C:Usersuser>mysqldump -u root -p airlines_test > C:...testairlines_test_dump.sql
Enter password: ******************
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
I fixed this by specifying the port to use: -P 3306:
C:Usersuser>mysqldump -u root -p -P 3306 airlines_test > C:...testairlines_test_dump.sql
Enter password: ******************
answered 14 mins ago
Karl BakerKarl Baker
1115
Try specifying the port. I'm using MySQL 8.0 on Windows but similar issues apply on Ubuntu. Without a port argument I got the same error:
C:Usersuser>mysqldump -u root -p airlines_test > C:...testairlines_test_dump.sql
Enter password: ******************
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
I fixed this by specifying the port to use: -P 3306:
C:Usersuser>mysqldump -u root -p -P 3306 airlines_test > C:...testairlines_test_dump.sql
Enter password: ******************
answered 14 mins ago
Karl BakerKarl Baker
1115
answered 14 mins ago
Karl BakerKarl Baker
1115
answered 14 mins ago
Karl BakerKarl Baker
1115
answered 14 mins ago
Karl BakerKarl Baker
1115
1115
add a comment |
add a comment |
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1024456%2fmysqldump-access-denied-error-on-ubuntu-with-mariadb-login-informations-are-c%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
