How to login to the MySQL in Ubuntu from Windows?
Clash Royale CLAN TAG#URR8PPP up vote
2
down vote
favorite
How to access MySQL directly with MySQL ac but skip the Ubuntu login?
As I PuTTY to MySQL server in Ubuntu, the first login is Ubuntu account. I would like to skip this part and login to the MySQL server with MySQL account directly.
Thanks!
login auto-login remote-login
asked May 24 at 2:40
Denise Wun
132
add a comment |Â
up vote
2
down vote
favorite
How to access MySQL directly with MySQL ac but skip the Ubuntu login?
As I PuTTY to MySQL server in Ubuntu, the first login is Ubuntu account. I would like to skip this part and login to the MySQL server with MySQL account directly.
Thanks!
login auto-login remote-login
asked May 24 at 2:40
Denise Wun
132
add a comment |Â
up vote
2
down vote
favorite
up vote
2
down vote
favorite
How to access MySQL directly with MySQL ac but skip the Ubuntu login?
As I PuTTY to MySQL server in Ubuntu, the first login is Ubuntu account. I would like to skip this part and login to the MySQL server with MySQL account directly.
Thanks!
login auto-login remote-login
asked May 24 at 2:40
Denise Wun
132
How to access MySQL directly with MySQL ac but skip the Ubuntu login?
As I PuTTY to MySQL server in Ubuntu, the first login is Ubuntu account. I would like to skip this part and login to the MySQL server with MySQL account directly.
Thanks!
login auto-login remote-login
asked May 24 at 2:40
Denise Wun
132
asked May 24 at 2:40
Denise Wun
132
asked May 24 at 2:40
Denise Wun
132
asked May 24 at 2:40
Denise Wun
132
132
add a comment |Â
add a comment |Â
1 Answer
1
active
oldest
votes
up vote
3
down vote
accepted
Use this syntax in command prompt:
mysql -h <mysql_server_url> -P <port_number> -u <username> -p
Example:
mysql -h xyz.rds.aws.com -P 3306 -u root -p
edited May 24 at 3:22
WinEunuuchs2Unix
34.3k756131
answered May 24 at 3:18
okcomputer_kid
714
Thanks okcomputer_kid. However, why i cannot login as root but can login as a normal user? and seems i cannot change password?
– Denise Wun
May 24 at 4:33
Have you lost your root password? If you have lost your password, you have to ssh connect to your ubuntu server , change root password there.
– okcomputer_kid
May 24 at 4:43
mysqladmin -u root -p password newpassUse this command to update your root password. Donot replace password with anything. Only replace newpass with your password
– okcomputer_kid
May 24 at 4:44
But I can login as root in ubuntu so the password is correct. Any other suggestion? Thanks!
– Denise Wun
May 24 at 6:22
Problem fixed after grant the privileges to root, thanks.
– Denise Wun
May 24 at 7:22
 |Â
show 1 more comment
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
3
down vote
accepted
Use this syntax in command prompt:
mysql -h <mysql_server_url> -P <port_number> -u <username> -p
Example:
mysql -h xyz.rds.aws.com -P 3306 -u root -p
edited May 24 at 3:22
WinEunuuchs2Unix
34.3k756131
answered May 24 at 3:18
okcomputer_kid
714
Thanks okcomputer_kid. However, why i cannot login as root but can login as a normal user? and seems i cannot change password?
– Denise Wun
May 24 at 4:33
Have you lost your root password? If you have lost your password, you have to ssh connect to your ubuntu server , change root password there.
– okcomputer_kid
May 24 at 4:43
mysqladmin -u root -p password newpassUse this command to update your root password. Donot replace password with anything. Only replace newpass with your password
– okcomputer_kid
May 24 at 4:44
But I can login as root in ubuntu so the password is correct. Any other suggestion? Thanks!
– Denise Wun
May 24 at 6:22
Problem fixed after grant the privileges to root, thanks.
– Denise Wun
May 24 at 7:22
 |Â
show 1 more comment
up vote
3
down vote
accepted
Use this syntax in command prompt:
mysql -h <mysql_server_url> -P <port_number> -u <username> -p
Example:
mysql -h xyz.rds.aws.com -P 3306 -u root -p
edited May 24 at 3:22
WinEunuuchs2Unix
34.3k756131
answered May 24 at 3:18
okcomputer_kid
714
Thanks okcomputer_kid. However, why i cannot login as root but can login as a normal user? and seems i cannot change password?
– Denise Wun
May 24 at 4:33
Have you lost your root password? If you have lost your password, you have to ssh connect to your ubuntu server , change root password there.
– okcomputer_kid
May 24 at 4:43
mysqladmin -u root -p password newpassUse this command to update your root password. Donot replace password with anything. Only replace newpass with your password
– okcomputer_kid
May 24 at 4:44
But I can login as root in ubuntu so the password is correct. Any other suggestion? Thanks!
– Denise Wun
May 24 at 6:22
Problem fixed after grant the privileges to root, thanks.
– Denise Wun
May 24 at 7:22
 |Â
show 1 more comment
up vote
3
down vote
accepted
up vote
3
down vote
accepted
Use this syntax in command prompt:
mysql -h <mysql_server_url> -P <port_number> -u <username> -p
Example:
mysql -h xyz.rds.aws.com -P 3306 -u root -p
edited May 24 at 3:22
WinEunuuchs2Unix
34.3k756131
answered May 24 at 3:18
okcomputer_kid
714
Use this syntax in command prompt:
mysql -h <mysql_server_url> -P <port_number> -u <username> -p
Example:
mysql -h xyz.rds.aws.com -P 3306 -u root -p
edited May 24 at 3:22
WinEunuuchs2Unix
34.3k756131
answered May 24 at 3:18
okcomputer_kid
714
edited May 24 at 3:22
WinEunuuchs2Unix
34.3k756131
edited May 24 at 3:22
WinEunuuchs2Unix
34.3k756131
edited May 24 at 3:22
WinEunuuchs2Unix
34.3k756131
34.3k756131
answered May 24 at 3:18
okcomputer_kid
714
answered May 24 at 3:18
okcomputer_kid
714
answered May 24 at 3:18
okcomputer_kid
714
714
Thanks okcomputer_kid. However, why i cannot login as root but can login as a normal user? and seems i cannot change password?
– Denise Wun
May 24 at 4:33
Have you lost your root password? If you have lost your password, you have to ssh connect to your ubuntu server , change root password there.
– okcomputer_kid
May 24 at 4:43
mysqladmin -u root -p password newpassUse this command to update your root password. Donot replace password with anything. Only replace newpass with your password
– okcomputer_kid
May 24 at 4:44
But I can login as root in ubuntu so the password is correct. Any other suggestion? Thanks!
– Denise Wun
May 24 at 6:22
Problem fixed after grant the privileges to root, thanks.
– Denise Wun
May 24 at 7:22
 |Â
show 1 more comment
Thanks okcomputer_kid. However, why i cannot login as root but can login as a normal user? and seems i cannot change password?
– Denise Wun
May 24 at 4:33
Have you lost your root password? If you have lost your password, you have to ssh connect to your ubuntu server , change root password there.
– okcomputer_kid
May 24 at 4:43
mysqladmin -u root -p password newpassUse this command to update your root password. Donot replace password with anything. Only replace newpass with your password
– okcomputer_kid
May 24 at 4:44
But I can login as root in ubuntu so the password is correct. Any other suggestion? Thanks!
– Denise Wun
May 24 at 6:22
Problem fixed after grant the privileges to root, thanks.
– Denise Wun
May 24 at 7:22
Thanks okcomputer_kid. However, why i cannot login as root but can login as a normal user? and seems i cannot change password?
– Denise Wun
May 24 at 4:33
Thanks okcomputer_kid. However, why i cannot login as root but can login as a normal user? and seems i cannot change password?
– Denise Wun
May 24 at 4:33
Have you lost your root password? If you have lost your password, you have to ssh connect to your ubuntu server , change root password there.
– okcomputer_kid
May 24 at 4:43
Have you lost your root password? If you have lost your password, you have to ssh connect to your ubuntu server , change root password there.
– okcomputer_kid
May 24 at 4:43
mysqladmin -u root -p password newpass Use this command to update your root password. Donot replace password with anything. Only replace newpass with your password– okcomputer_kid
May 24 at 4:44
mysqladmin -u root -p password newpass Use this command to update your root password. Donot replace password with anything. Only replace newpass with your password– okcomputer_kid
May 24 at 4:44
But I can login as root in ubuntu so the password is correct. Any other suggestion? Thanks!
– Denise Wun
May 24 at 6:22
But I can login as root in ubuntu so the password is correct. Any other suggestion? Thanks!
– Denise Wun
May 24 at 6:22
Problem fixed after grant the privileges to root, thanks.
– Denise Wun
May 24 at 7:22
Problem fixed after grant the privileges to root, thanks.
– Denise Wun
May 24 at 7:22
 |Â
show 1 more comment
Â
draft saved
draft discarded
Â
draft saved
draft discarded
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%2f1039627%2fhow-to-login-to-the-mysql-in-ubuntu-from-windows%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