enable root access from remote machines

Posted on 2006-03-22
Last Modified: 2008-02-20

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?

Question by:NeilT
    LVL 14

    Expert Comment


    Edit /etc/ssh/sshd_config, and set

    PermitRootLogin yes

    LVL 14

    Accepted Solution


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

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

    LVL 3

    Author Comment


    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?


    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now