Bsrgvty

Password maker in C#

What is this welding tool I found in my attic?

As a DM, how to avoid unconscious metagaming when dealing with a high AC character?

Is killing off one of my queer characters homophobic?

What's the point of this scene involving Flash Thompson at the airport?

Are lithium batteries allowed in the International Space Station?

When did the Roman Empire fall according to contemporaries?

Why would guns not work in the dungeon?

If the derivative of a function is square of it then it is constant

Bob's unnecessary trip to the shops

Why does the trade federation become so alarmed upon learning the ambassadors are Jedi Knights?

How many matrices satisfy this equality?

Won 50K! Now what should I do with it

Robbers: The Hidden OEIS Substring

latinate or other words of foreign origin as opposed to Germanic words

Can I call 112 to check a police officer's identity in the Czech Republic?

What would be the ideal melee weapon made of "Phase Metal"?

Does Google Maps take into account hills/inclines for route times?

Why did the Japanese attack the Aleutians at the same time as Midway?

How does one stock fund's charge of 1% more in operating expenses than another fund lower expected returns by 10%?

Dropping outliers based on "2.5 times the RMSE"

Are local nested functions possible in elisp?

What does `[$'rn']` mean?

Supporting developers who insist on using their pet language

mysqldump “Access denied” error on ubuntu with mariadb (login informations are correct)

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 ErrorMariadb 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 LTSUnable to start mysql after deleting all the users and reinstalling all mysql packagePermission denied after trying to create mysqldump, even after creating .my.cnf file

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

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

share|improve this question

asked Apr 12 '18 at 19:39

GoniosGonios

122 bronze badges

add a comment | 

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

share|improve this question

asked Apr 12 '18 at 19:39

GoniosGonios

122 bronze badges

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

share|improve this question

asked Apr 12 '18 at 19:39

GoniosGonios

122 bronze badges

mysqldump: Got error: 1045; "Access denied for user 'db_user-backups'@'localhosts' (using password: YES)" when trying to connect

sudo mysqldump --defaults-file=/etc/mysql/my.cnf lom

[mysqldump]
user=db_user_backups
password=MyS3cretP4ssw0rD!

share|improve this question

asked Apr 12 '18 at 19:39

GoniosGonios

122 bronze badges

share|improve this question

asked Apr 12 '18 at 19:39

GoniosGonios

122 bronze badges

asked Apr 12 '18 at 19:39

GoniosGonios

122 bronze badges

asked Apr 12 '18 at 19:39

GoniosGonios

122 bronze badges

2 Answers
2

active

oldest

votes

0

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.

share|improve this answer

answered Apr 19 '18 at 4:18

TannettoTannetto

41133 silver badges77 bronze badges

add a comment | 

0

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: ******************

share|improve this answer

answered Apr 15 at 2:22

Karl BakerKarl Baker

11155 bronze badges

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
);



);

draft saved

draft discarded

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

Name

Email

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

Name

Email

Required, but never shown

0

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.

share|improve this answer

answered Apr 19 '18 at 4:18

TannettoTannetto

41133 silver badges77 bronze badges

add a comment | 

0

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.

share|improve this answer

answered Apr 19 '18 at 4:18

TannettoTannetto

41133 silver badges77 bronze badges

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.

share|improve this answer

answered Apr 19 '18 at 4:18

TannettoTannetto

41133 silver badges77 bronze badges

GRANT ALL PRIVILEGES ON *.* TO db_user-backups@'localhosts' IDENTIFIED BY 'password' with grant option;

flush privileges;

share|improve this answer

answered Apr 19 '18 at 4:18

TannettoTannetto

41133 silver badges77 bronze badges

answered Apr 19 '18 at 4:18

TannettoTannetto

41133 silver badges77 bronze badges

answered Apr 19 '18 at 4:18

TannettoTannetto

41133 silver badges77 bronze badges

0

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: ******************

share|improve this answer

answered Apr 15 at 2:22

Karl BakerKarl Baker

11155 bronze badges

add a comment | 

0

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: ******************

share|improve this answer

answered Apr 15 at 2:22

Karl BakerKarl Baker

11155 bronze badges

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: ******************

share|improve this answer

answered Apr 15 at 2:22

Karl BakerKarl Baker

11155 bronze badges

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

C:Usersuser>mysqldump -u root -p -P 3306 airlines_test > C:...testairlines_test_dump.sql
Enter password: ******************

share|improve this answer

answered Apr 15 at 2:22

Karl BakerKarl Baker

11155 bronze badges

answered Apr 15 at 2:22

Karl BakerKarl Baker

11155 bronze badges

answered Apr 15 at 2:22

Karl BakerKarl Baker

11155 bronze badges