Bsrgvty

How much do sea levels rise due to thermal expansion?

Why does Sonny say they call Michael "Giogali"?

Any way to automatically find and save any .ai file as .svg?

Why is beatboxing called 「ヒューマンビートボックス」?

SSD or HDD for server

Should I avoid "big words" when writing to a younger audience?

In "Avatar: The Last Airbender" can a metalbender bloodbend if there is metal in our blood?

Do you say "good game" after a game in which your opponent played poorly?

Incorrect mmap behavior when assembly files included in the project

Is any one against the rational teachings of Maimonides?

Will Brexit potentially have an impact on intra-Schengen flights by EasyJet in November?

"inuendo" in a piano score

Is it now possible to undetectably cross the Arctic Ocean on ski/kayak?

How can I add a recepticle to this junction box full of push splices?

How to say dandruff in Esperanto?

Can digital computers understand infinity?

When did 5 foot squares become standard in D&D?

Why exactly is the answer 50 ohms?

Is there a push, in the United States, to use gender-neutral language and gender pronouns (when they are given)?

Very Massive Relativistic Body

"Table" method for expanding brackets vs "each term in the first bracket gets multiplied by each term in the second bracket"

Meaning of 'sick' in 'Kylie Jenner is showing off the new sick ride in her driveway'

3-prong to 4-prong conversion - EXTRA MISLABELLED WIRES - Dryer cable upgrade and installation

Is a list of the most common English words copyrightable?

how to login mysql shell when mysql have no password

MySQL Access denied for user 'root'@'localhost'Unable to Login as root after mysql service restartUbuntu 14 installing phpmyadmin newbie questionMysql error when running Laravel php migrationsi have mysql 8.0.2 installed on my ubuntu 16.04.can not open it through terminal. so what to do now?ERROR 1698 (28000): Access denied for user 'root'@'localhost' at Ubuntu 18.04ERROR 1698 (28000): Access denied for user 'root'@'localhost'Problem in accessing to Mysql

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

0

I got this error:

root@sys3026:/home/sys3026# mysql --user=root --password 
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Any one please help me.
Thanks in advance..

permissions login mysql

share|improve this question

edited May 16 '17 at 5:14

muru

1

asked May 16 '17 at 4:49

veerakrishna pachhipalaveerakrishna pachhipala

111 silver badge22 bronze badges

add a comment
 | 

0

I got this error:

root@sys3026:/home/sys3026# mysql --user=root --password 
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Any one please help me.
Thanks in advance..

permissions login mysql

share|improve this question

edited May 16 '17 at 5:14

muru

1

asked May 16 '17 at 4:49

veerakrishna pachhipalaveerakrishna pachhipala

111 silver badge22 bronze badges

add a comment
 | 

I got this error:

root@sys3026:/home/sys3026# mysql --user=root --password 
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Any one please help me.
Thanks in advance..

permissions login mysql

share|improve this question

edited May 16 '17 at 5:14

muru

1

asked May 16 '17 at 4:49

veerakrishna pachhipalaveerakrishna pachhipala

111 silver badge22 bronze badges

root@sys3026:/home/sys3026# mysql --user=root --password 
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

share|improve this question

edited May 16 '17 at 5:14

muru

1

asked May 16 '17 at 4:49

veerakrishna pachhipalaveerakrishna pachhipala

111 silver badge22 bronze badges

share|improve this question

edited May 16 '17 at 5:14

muru

1

asked May 16 '17 at 4:49

veerakrishna pachhipalaveerakrishna pachhipala

111 silver badge22 bronze badges

edited May 16 '17 at 5:14

muru

1

edited May 16 '17 at 5:14

muru

1

asked May 16 '17 at 4:49

veerakrishna pachhipalaveerakrishna pachhipala

111 silver badge22 bronze badges

asked May 16 '17 at 4:49

veerakrishna pachhipalaveerakrishna pachhipala

111 silver badge22 bronze badges

4 Answers
4

active

oldest

votes

0

Try this.

This is the command to run mysql when no password is set, But If you just installed it and you did not set any password, I am pretty sure it still has a random password that can be found in logs located in /var/log/mysql.

mysql -u root

share|improve this answer

answered May 16 '17 at 5:49

Ishan JainIshan Jain

12122 bronze badges

add a comment
 | 

0

If your database has no password, just leave out the --password parameter.

$ mysql --user=root

Reference:

• https://stackoverflow.com/questions/3843973/mysql-is-prompting-for-password-even-though-my-password-is-empty

share|improve this answer

edited May 23 '17 at 12:39

Community♦

1

answered May 16 '17 at 11:12

MelebiusMelebius

7,10755 gold badges2929 silver badges5353 bronze badges

add a comment
 | 

0

If you have forgotten your password or you can not login you can always run mysql in a "safe_mode". Which allows you to access it without any password restriction - to change the root password or adjust something else if something went wrong.

systemctl stop mysql
sudo mysqld_safe --skip-grant-tables &

Now you can access the mysql server without a password.

mysql -uroot

Add a new password to the root user in the mysql shell

use mysql;
update user set password=PASSWORD("newpassword") where User='root';
flush privileges;

Now restart it in normal mode again and it will work with the new password.

systemctl stop mysql
systemctl start mysql

share|improve this answer

edited May 22 '18 at 3:40

fosslinux

2,47822 gold badges2222 silver badges3838 bronze badges

answered May 16 '17 at 10:41

ZiazisZiazis

1,90355 silver badges2020 bronze badges

add a comment
 | 

0

When a MySQL user is configured to use auth_socket (instead of mysql_native_password), as it is by default in Ubuntu 18.04, you can log-in as root (for example) in the following way:

sudo mysql -u'root'

or just:

sudo mysql

References:

• Digital Ocean: How To Install MySQL on Ubuntu 18.04 - read Step 3

share|improve this answer

answered Mar 28 at 19:45

pa4080pa4080

17.6k77 gold badges3737 silver badges8383 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/4.0/"u003ecc by-sa 4.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%2f915585%2fhow-to-login-mysql-shell-when-mysql-have-no-password%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Try this.

This is the command to run mysql when no password is set, But If you just installed it and you did not set any password, I am pretty sure it still has a random password that can be found in logs located in /var/log/mysql.

mysql -u root

share|improve this answer

answered May 16 '17 at 5:49

Ishan JainIshan Jain

12122 bronze badges

add a comment
 | 

0

Try this.

This is the command to run mysql when no password is set, But If you just installed it and you did not set any password, I am pretty sure it still has a random password that can be found in logs located in /var/log/mysql.

mysql -u root

share|improve this answer

answered May 16 '17 at 5:49

Ishan JainIshan Jain

12122 bronze badges

add a comment
 | 

Try this.

This is the command to run mysql when no password is set, But If you just installed it and you did not set any password, I am pretty sure it still has a random password that can be found in logs located in /var/log/mysql.

mysql -u root

share|improve this answer

answered May 16 '17 at 5:49

Ishan JainIshan Jain

12122 bronze badges

share|improve this answer

answered May 16 '17 at 5:49

Ishan JainIshan Jain

12122 bronze badges

answered May 16 '17 at 5:49

Ishan JainIshan Jain

12122 bronze badges

answered May 16 '17 at 5:49

Ishan JainIshan Jain

12122 bronze badges

0

If your database has no password, just leave out the --password parameter.

$ mysql --user=root

Reference:

• https://stackoverflow.com/questions/3843973/mysql-is-prompting-for-password-even-though-my-password-is-empty

share|improve this answer

edited May 23 '17 at 12:39

Community♦

1

answered May 16 '17 at 11:12

MelebiusMelebius

7,10755 gold badges2929 silver badges5353 bronze badges

add a comment
 | 

0

If your database has no password, just leave out the --password parameter.

$ mysql --user=root

Reference:

• https://stackoverflow.com/questions/3843973/mysql-is-prompting-for-password-even-though-my-password-is-empty

share|improve this answer

edited May 23 '17 at 12:39

Community♦

1

answered May 16 '17 at 11:12

MelebiusMelebius

7,10755 gold badges2929 silver badges5353 bronze badges

add a comment
 | 

If your database has no password, just leave out the --password parameter.

$ mysql --user=root

Reference:

• https://stackoverflow.com/questions/3843973/mysql-is-prompting-for-password-even-though-my-password-is-empty

share|improve this answer

edited May 23 '17 at 12:39

Community♦

1

answered May 16 '17 at 11:12

MelebiusMelebius

7,10755 gold badges2929 silver badges5353 bronze badges

$ mysql --user=root

share|improve this answer

edited May 23 '17 at 12:39

Community♦

1

answered May 16 '17 at 11:12

MelebiusMelebius

7,10755 gold badges2929 silver badges5353 bronze badges

edited May 23 '17 at 12:39

Community♦

1

edited May 23 '17 at 12:39

Community♦

1

answered May 16 '17 at 11:12

MelebiusMelebius

7,10755 gold badges2929 silver badges5353 bronze badges

answered May 16 '17 at 11:12

MelebiusMelebius

7,10755 gold badges2929 silver badges5353 bronze badges

0

If you have forgotten your password or you can not login you can always run mysql in a "safe_mode". Which allows you to access it without any password restriction - to change the root password or adjust something else if something went wrong.

systemctl stop mysql
sudo mysqld_safe --skip-grant-tables &

Now you can access the mysql server without a password.

mysql -uroot

Add a new password to the root user in the mysql shell

use mysql;
update user set password=PASSWORD("newpassword") where User='root';
flush privileges;

Now restart it in normal mode again and it will work with the new password.

systemctl stop mysql
systemctl start mysql

share|improve this answer

edited May 22 '18 at 3:40

fosslinux

2,47822 gold badges2222 silver badges3838 bronze badges

answered May 16 '17 at 10:41

ZiazisZiazis

1,90355 silver badges2020 bronze badges

add a comment
 | 

0

If you have forgotten your password or you can not login you can always run mysql in a "safe_mode". Which allows you to access it without any password restriction - to change the root password or adjust something else if something went wrong.

systemctl stop mysql
sudo mysqld_safe --skip-grant-tables &

Now you can access the mysql server without a password.

mysql -uroot

Add a new password to the root user in the mysql shell

use mysql;
update user set password=PASSWORD("newpassword") where User='root';
flush privileges;

Now restart it in normal mode again and it will work with the new password.

systemctl stop mysql
systemctl start mysql

share|improve this answer

edited May 22 '18 at 3:40

fosslinux

2,47822 gold badges2222 silver badges3838 bronze badges

answered May 16 '17 at 10:41

ZiazisZiazis

1,90355 silver badges2020 bronze badges

add a comment
 | 

If you have forgotten your password or you can not login you can always run mysql in a "safe_mode". Which allows you to access it without any password restriction - to change the root password or adjust something else if something went wrong.

systemctl stop mysql
sudo mysqld_safe --skip-grant-tables &

Now you can access the mysql server without a password.

mysql -uroot

Add a new password to the root user in the mysql shell

use mysql;
update user set password=PASSWORD("newpassword") where User='root';
flush privileges;

Now restart it in normal mode again and it will work with the new password.

systemctl stop mysql
systemctl start mysql

share|improve this answer

edited May 22 '18 at 3:40

fosslinux

2,47822 gold badges2222 silver badges3838 bronze badges

answered May 16 '17 at 10:41

ZiazisZiazis

1,90355 silver badges2020 bronze badges

systemctl stop mysql
sudo mysqld_safe --skip-grant-tables &

mysql -uroot

use mysql;
update user set password=PASSWORD("newpassword") where User='root';
flush privileges;

systemctl stop mysql
systemctl start mysql

share|improve this answer

edited May 22 '18 at 3:40

fosslinux

2,47822 gold badges2222 silver badges3838 bronze badges

answered May 16 '17 at 10:41

ZiazisZiazis

1,90355 silver badges2020 bronze badges

edited May 22 '18 at 3:40

fosslinux

2,47822 gold badges2222 silver badges3838 bronze badges

edited May 22 '18 at 3:40

fosslinux

2,47822 gold badges2222 silver badges3838 bronze badges

answered May 16 '17 at 10:41

ZiazisZiazis

1,90355 silver badges2020 bronze badges

answered May 16 '17 at 10:41

ZiazisZiazis

1,90355 silver badges2020 bronze badges

0

When a MySQL user is configured to use auth_socket (instead of mysql_native_password), as it is by default in Ubuntu 18.04, you can log-in as root (for example) in the following way:

sudo mysql -u'root'

or just:

sudo mysql

References:

• Digital Ocean: How To Install MySQL on Ubuntu 18.04 - read Step 3

share|improve this answer

answered Mar 28 at 19:45

pa4080pa4080

17.6k77 gold badges3737 silver badges8383 bronze badges

add a comment
 | 

0

When a MySQL user is configured to use auth_socket (instead of mysql_native_password), as it is by default in Ubuntu 18.04, you can log-in as root (for example) in the following way:

sudo mysql -u'root'

or just:

sudo mysql

References:

• Digital Ocean: How To Install MySQL on Ubuntu 18.04 - read Step 3

share|improve this answer

answered Mar 28 at 19:45

pa4080pa4080

17.6k77 gold badges3737 silver badges8383 bronze badges

add a comment
 | 

When a MySQL user is configured to use auth_socket (instead of mysql_native_password), as it is by default in Ubuntu 18.04, you can log-in as root (for example) in the following way:

sudo mysql -u'root'

or just:

sudo mysql

References:

• Digital Ocean: How To Install MySQL on Ubuntu 18.04 - read Step 3

share|improve this answer

answered Mar 28 at 19:45

pa4080pa4080

17.6k77 gold badges3737 silver badges8383 bronze badges

sudo mysql -u'root'

sudo mysql

share|improve this answer

answered Mar 28 at 19:45

pa4080pa4080

17.6k77 gold badges3737 silver badges8383 bronze badges

answered Mar 28 at 19:45

pa4080pa4080

17.6k77 gold badges3737 silver badges8383 bronze badges

answered Mar 28 at 19:45

pa4080pa4080

17.6k77 gold badges3737 silver badges8383 bronze badges