• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 320
  • Last Modified:

How get access to Mysql from fron end

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

thanks
0
diegomirner
Asked:
diegomirner
1 Solution
 
ahoffmannCommented:
> .. 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.
0
 
xDamoxCommented:
Hi,

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
0
 
pjedmondCommented:
How about downloading webmin:

www.webmin.com

Install:

rpm -ivh <webminrpm name>

Start webmin:

/etc/init.d/webmin start

Login:

http://hostname:10000/

Select servers

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

HTH:)
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
pjedmondCommented:
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.

HTH:)
0
 
psimationCommented:
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.
 OR
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.
0
 
ppfoongCommented:

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.

0
 
diegomirnerAuthor Commented:
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)

help

thanks

0
 
pjedmondCommented:
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:

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

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:

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

HTH:)

0
 
ahoffmannCommented:
> .. 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.)
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now