mysql front and cpanel
Moderator: General Moderators
- shiznatix
- DevNet Master
- Posts: 2745
- Joined: Tue Dec 28, 2004 5:57 pm
- Location: Tallinn, Estonia
- Contact:
mysql front and cpanel
ok i want to connect to a database using mysql front because its a trillian times easier in front than it is in phpmyadmin. so i create a new user, give that user full permission on the db then in front i have that as the selected db and have everything setup but it wont connect...ever. and yes i put a % for the access host just for testing purposes for now but to no avail. anyone know of any reasons why?
I've experienced that it's the most easiest to do this from a shell...
Code: Select all
mysql -u root -p -h mysql.example.com
create database example;
grant all on database.* to 'user'@'*' identified by 'password';
exit;
mysqladmin -u root -p -h mysql.example.com reload- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
Are you on a shared host, call up tech support and ask them to give you shell access, then use a program like putty. If they won't give you shell access consider moving to a host that will, shell access and safe mode being off are always things I look for when I choose a host.
If on a dedi you should already know how to access your shell.
If on a dedi you should already know how to access your shell.
- shiznatix
- DevNet Master
- Posts: 2745
- Joined: Tue Dec 28, 2004 5:57 pm
- Location: Tallinn, Estonia
- Contact:
uhhh direct, i saw the php tunnel option but damned if i know how to use it
errr edit: sorry didnt do any research before i posted that one, got it working perfectly, many thanks.
WOOT
errr edit: sorry didnt do any research before i posted that one, got it working perfectly, many thanks.
WOOT
Last edited by shiznatix on Mon Jul 25, 2005 1:55 pm, edited 1 time in total.
lol, its pretty easy. If you can't access the db via an IP address (Most shared hosts won't allow direct access) You should use their tunneling option. In your download there is a PHP file phpMySQL.phpshiznatix wrote:uhhh direct, i saw the php tunnel option but damned if i know how to use it
Put this file on your server and call that URL in the MySql-Front setup.