Access mysql without a Control Panel?

Is there anyone that can point me out what tool to use to easily access my mysql database. The site does support SSH , doesnt have phpmyadmin. I dont feel like installing phpmyadmin first on my ftp client isnt there a easier way to acess the database.

 

The mysql binary will give you a SQL command line to the database. It might be in your path. Otherwise, find where mysql is installed("locate mysql"), and then there's a "bin" sub directory. For example, on my system, it's /usr/local/mysql/bin/mysql, so I issue:

/usr/local/mysql/bin/mysql -p mydatabasename

"-p" forces it to ask for a password, and "mydatabasename" is the name of my database.

Good luck.


--
Derek

 

Do you know the address of your MySql Server? it might be an IP address or something similar. Use EMS MySQL Manager to connect to your Mysql Server and manage your database. Download the trial version and you are all set.

Cheers,

 

Just install phpmyadmin. It's as easy as dumping it in a directory on your webserver. or for that matter, install apache, php and phpmyadmin at home and manage your mysql server from there.

 

A useful thing about mysql (the utility, not the database) if the output is too wide for the command line, use \G instead of semicolon:

select * from user\G

J.D.

 

That's an awesome tip. Thanks!


--
Derek

 

If you have command line access from your computer (with out prior arrangement) as suggested in other posts.

MOVE

Don't just walk away from your host RUN

 

Thanks for the info

 

Care to elaborate?

J.D.

 

would this work?
1. download mysql control center
2. install it on your local workstation
3. connect to your server
4. access your database through mysql control center

i've not tried this out... there may be problems connecting to the webserver...

 

One thing to keep in mind is that it is always a bad idea to open MySQL ports in the firewall. It opens too many possibilities for hackers to poke at the server. In a proper configuration, MySQL admin would connect to the machine through some other mechanism (e.g. ssh, tunnel, web, etc) and connect to the server locally.

Another security concern is that if your server is shared and you can run the mysql utility at any time, this means that other folks on the same server can do the same (sometimes they can even upload better tools for this) and that they can also poke the server trying to get to other people's databases.

J.D.

 

Normally the database server would only be accessible from the webserver machine, not from the internet.

 

In some cases; you can allow remote access; as long as the host knows to allow the ip.

 

Any host that dose not provide safe secure tools for its customers to use is either incompetent or dose not care about it's customers needs.

Nornmal security protocol is for only root to have command line access, as it is much easyer to breakin and take total control of a server from the inside.

 

Any one care to help me out i cant it working. Maybe a pm. Thanks in advance

 

What's the problem? You can PM me, if you'd like.

J.D.

 

I got it working, i was a bit to fast. I have downloaded putty from here, http://www.chiark.greenend.org.uk/~sgtatham/putty/ for easy ssh access.

Im going to use there mysql monitor
/usr/local/mysql/bin/mysql -u loginname -h servername -p databasename [Enter]

or there webinterface
http://www.widexs.nl/examples/mysql.tar.gz Havnt checked the file yet might be in Dutch .

Using the commands like

cd /opt/guide/www.yourdomain.nl/HTML [Enter]
tar xvfz mysql.tar.gz [Enter]

cd /opt/guide/www.yourdomain.nl/HTML [Enter]
chown -R username:user mysql [Enter]
chmod -R 755 mysql [Enter]

Thought that was quit a good start for a newbie?

 

Thanks for the offer i forgot to say

 

That is a very good tip. Thanks J.D.