[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

enable root access from remote machines

Posted on 2006-03-22
3
Medium Priority
?
1,578 Views
Last Modified: 2008-02-20
Hi

I've installed mysql4 internally and took off the "enable root access from remote machines" tick upon install.

We now want to be able to access root  from remote machines, how can i do this please?

Neil
0
Comment
Question by:Neil Thompson
  • 2
3 Comments
 
LVL 14

Expert Comment

by:ppfoong
ID: 16258074

Edit /etc/ssh/sshd_config, and set

PermitRootLogin yes

0
 
LVL 14

Accepted Solution

by:
ppfoong earned 2000 total points
ID: 16258094

If you refer to root in MySQL, then issue the MySQL command:

GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'password';

0
 
LVL 3

Author Comment

by:Neil Thompson
ID: 16258263
Hi

in GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'password'; is password our actual password or should i leave the text password?

sorry if it's dumb, i'm new to this.

Also on windows system so couldn't find a PermitRootLogin to change?

Neil
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month20 days, 7 hours left to enroll

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question