mysqldump “Access denied†error on ubuntu with mariadb (login informations are correct)
Clash Royale CLAN TAG#URR8PPP up vote
0
down vote
favorite
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 at 19:39
Gonios
11
add a comment |Â
up vote
0
down vote
favorite
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 at 19:39
Gonios
11
add a comment |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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 at 19:39
Gonios
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 at 19:39
Gonios
11
asked Apr 12 at 19:39
Gonios
11
asked Apr 12 at 19:39
Gonios
11
asked Apr 12 at 19:39
Gonios
11
asked Apr 12 at 19:39
Gonios
11
11
add a comment |Â
add a comment |Â
1 Answer
1
active
oldest
votes
up vote
0
down vote
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 at 4:18
Tannetto
37127
add a comment |Â
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
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 at 4:18
Tannetto
37127
add a comment |Â
up vote
0
down vote
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 at 4:18
Tannetto
37127
add a comment |Â
up vote
0
down vote
up vote
0
down vote
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 at 4:18
Tannetto
37127
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 at 4:18
Tannetto
37127
answered Apr 19 at 4:18
Tannetto
37127
answered Apr 19 at 4:18
Tannetto
37127
answered Apr 19 at 4:18
Tannetto
37127
37127
add a comment |Â
add a comment |Â
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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