Page 1 of 1

mysql front and cpanel

Posted: Mon Jul 25, 2005 11:40 am
by shiznatix
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?

Posted: Mon Jul 25, 2005 11:46 am
by timvw
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

Posted: Mon Jul 25, 2005 12:06 pm
by shiznatix
sorry for being stupid but how do i actually run that script on my server?

Posted: Mon Jul 25, 2005 12:09 pm
by John Cartwright

Posted: Mon Jul 25, 2005 12:18 pm
by shiznatix
snap safe mode killin me

Warning: shell_exec(): Cannot execute using backquotes in Safe Mode in /home/wesmok2/public_html/shizImg/exec.php on line 11

and i cant have it disabled, any other ideas?

Posted: Mon Jul 25, 2005 1:21 pm
by josh
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.

Posted: Mon Jul 25, 2005 1:25 pm
by hawleyjr
MySQL-Front uses php tunneling so you can access a db via local host vs an IP address. Are you attempting to connect via direct or via a tunnel?

Posted: Mon Jul 25, 2005 1:51 pm
by shiznatix
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

Posted: Mon Jul 25, 2005 1:53 pm
by hawleyjr
shiznatix wrote:uhhh direct, i saw the php tunnel option but damned if i know how to use it
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.php

Put this file on your server and call that URL in the MySql-Front setup.

Posted: Mon Jul 25, 2005 1:56 pm
by shiznatix
ur too fast for my edit :D

Posted: Mon Jul 25, 2005 1:57 pm
by hawleyjr
shiznatix wrote:your too fast
If I got a $1 for everytime I heard that...lol, np

Posted: Mon Jul 25, 2005 2:08 pm
by timvw
I feel sorry for your GF :)

Posted: Mon Jul 25, 2005 2:09 pm
by hawleyjr
:lol: :lol: :lol: :lol: :lol:

Posted: Mon Jul 25, 2005 3:08 pm
by shiznatix
HAHAHAHAHA, man that was great