How get access to Mysql from fron end

Posted on 2006-05-04
Last Modified: 2012-05-05
Hi , i need to have access from my MySql frontend to MySql with its runing in one Fedora 4 server.i supoust that i have to publicate the directories where all sql its , but i dont know , help please experts

Question by:diegomirner
    LVL 51

    Expert Comment

    > .. need to have access from my MySql frontend to MySql  could you please explain what you mean here?
    use mysql or mysqlGUI

    > .. supoust that i have to publicate the directories where all sql its ..
    do you mean the database?
    then copying the directory is not a good idea, usually. You access the databse through proper clients only.
    LVL 16

    Expert Comment


    As suggest by ahoffmann you will need to use mysql to connect to your mysql database issue
    the following:

    mysql -h locahost -u root -p

    This will connect to the localhost with the username root and once you hit enter you
    will be prompt for a password
    LVL 22

    Expert Comment

    How about downloading webmin:


    rpm -ivh <webminrpm name>

    Start webmin:

    /etc/init.d/webmin start



    Select servers

    Select mySQL.....and off you go:)

    LVL 22

    Expert Comment

    If it is a hosted mySQL server by a hosting provider, then they possibly provide a piece of software called mySQL phpAdin. This provides a graphical web based front end to enable you to view the data and databases.

    LVL 17

    Expert Comment

    If the MySQL server is located at your ISP and you want a graphical interface on your PC at home to administer your database, then you need one of 2 things:

    1) phpmyadmin configured on a webserver that has access to the mysql server.
    2) mysql gui application installed on your PC correctly configured to communicate with the mysql server.

    In most cases, mysql runs on the same server as the websites do at many ISP's, so option 1) is the easiest to implement. You simply download phpmyadmin, stick it in a webfolder and the configure it .

    For option 2), the mysql server needs to allow connections to port 3306, AND the database permissions needs to allow connections from hosts other than "localhost" - some ISP's do not open this port nor do they allow connections from other hosts, so you will have to find out from them first.
    LVL 14

    Expert Comment


    If you are talking about you have the MySQL frontend and want to connect to your MySQL server in a Linux machine, then you need to ensure that:

    1. there is no "skip-networking" configured to the MySQL server in its my.cnf file.

    2. you have a user account and password in MySQL system, associated with your IP address or domain name, or granted to your whole network or to everybody, that you can use to make MySQL connection with it.

    3. if the server is 4.1 or newer, your client supports this newer version of MySQL. With old client, you need to explicitly inform the server to use OLD_PASSWORD for the user account.

    If you need a frontend, you can get one from MySQL download site, or get SQLyog, or install phpMyAdmin if your server also running a web server with PHP enabled.


    Author Comment

    Hi , i install the webmin and works , but wen i try to get in on the Database , i have this :

    DBI connect failed : Access denied for user 'root'@'localhost' (using password: NO)



    LVL 22

    Expert Comment

    You need to set a password for root@localhost:

    First at the command prompt, connect to mySQL:

    >mysql -h mysql -u root -p

    Enter password when prompted, then

    >SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');

    If there is a need to use 'old style' passwords then you need to read here:

    Which means that your line becomes:

    >SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('newpwd');

    If you need to reset the root password because you don't know what it is, then instructions are here:


    LVL 51

    Accepted Solution

    > .. PASSWORD() ... OLD_PASSWORD()
    keep in mind that the usage/behaviour of these functions depend on how mysqld was configured
    if you have a mysql > 4.1.x with the new password hash, then you need to have a compliant client (mysql, correspondig PHP module etc.)

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    I am a long time windows user and for me it is normal to have spaces in directory and file names. Changing to Linux I found myself frustrated when I moved my windows data over to my new Linux computer. The problem occurs when at the command line.…
    Little introduction about CP: CP is a command on linux that use to copy files and folder from one location to another location. Example usage of CP as follow: cp /myfoder /pathto/destination/folder/ cp abc.tar.gz /pathto/destination/folder/ab…
    Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    728 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

    20 Experts available now in Live!

    Get 1:1 Help Now