mysql front and cpanel

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

mysql front and cpanel

Post 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?
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post 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
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

Post by shiznatix »

sorry for being stupid but how do i actually run that script on my server?
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

Post 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?
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Post 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.
User avatar
hawleyjr
BeerMod
Posts: 2170
Joined: Tue Jan 13, 2004 4:58 pm
Location: Jax FL & Spokane WA USA

Post 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?
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

Post 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
Last edited by shiznatix on Mon Jul 25, 2005 1:55 pm, edited 1 time in total.
User avatar
hawleyjr
BeerMod
Posts: 2170
Joined: Tue Jan 13, 2004 4:58 pm
Location: Jax FL & Spokane WA USA

Post 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.
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

Post by shiznatix »

ur too fast for my edit :D
User avatar
hawleyjr
BeerMod
Posts: 2170
Joined: Tue Jan 13, 2004 4:58 pm
Location: Jax FL & Spokane WA USA

Post by hawleyjr »

shiznatix wrote:your too fast
If I got a $1 for everytime I heard that...lol, np
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

I feel sorry for your GF :)
User avatar
hawleyjr
BeerMod
Posts: 2170
Joined: Tue Jan 13, 2004 4:58 pm
Location: Jax FL & Spokane WA USA

Post by hawleyjr »

:lol: :lol: :lol: :lol: :lol:
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

Post by shiznatix »

HAHAHAHAHA, man that was great
Post Reply