Any1 uses phpMyAdmin

They have: 80 posts

Joined: Feb 2003

Im that new to MySQL , i dont have my own server , so im using my ISP's , i ve installed phpBB2 on the domain , does this mean i have MySQL enabled on my site?

I was told i ll need a utility to access the MySQL database , so i somewhat found this utility call phpMyAdmin , uploaded onto my site but what does it do? i ve ask the help forum on thier site , but im not getting a single reply , so any help would be greatly appreciated.

Many Thx

Busy's picture

He has: 6,151 posts

Joined: May 2001

do you have php installed (working) on the server?
in notepad put

<?php
$test
= "works" echo "it $test"
?>

save it as test.php, upload it and point your browser to it, if you see what you typed php isn't working, if you see "it works" (no quotes) even in source code php is running
If you point your browser to the phpmyadmin folder and it works, you have it installed, if you get an error or see lines of code it's not installed. most IP's don't offer server side stuff.

phpmyadmin is like a mysql editor, if you are installing phpbb just create a new database (first page bottom) and add the name of the database to the phpbb install option.
don't forget to delete the install and other files mentioned after installing.

Suzanne's picture

She has: 5,507 posts

Joined: Feb 2000

mysql.com and php.net can help if you use their search features for specific questions about functions, et cetera. If you don't have PHP and you don't have MySQL, PHPMyAdmin won't help you. Check with the host first to make sure you have them!

They have: 80 posts

Joined: Feb 2003

Thx Busy , then i must be in luck , it just says

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

Error

MySQL said:

Access denied for user: '[email protected]' (Using password: NO)

i know i have php and Asp working on it , im just a tat worry that i might screw up something on the config.inc file and they will suspend my account ^o^

theere are sooooooo many strings there , is this where i put the username and password ?

$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables)

i know some peeps prob say with my lack of knowledge i shouldnt go with 100 yrds of MySQL , but i really want to try and get it going so i can try and do something useful

Many thx

Busy's picture

He has: 6,151 posts

Joined: May 2001

you shouldn't be able to touch the config file, unless your talking of the phpadmin one, ask your IP for the paths etc as what you may be doing could be a real quick exit from their services, better to be safe than sorry - they might even install phpadmin for you

They have: 80 posts

Joined: Feb 2003

My ISP put the MySqlAmin link on their page , and reading thru their literature , they stated that they do not provide any support beyond having Mysql installed , Sad

Anyway i think i ve somewhat half way there , on trying to access the index.php file , it snow says "Wrong username/password. Access denied."

Confused but im using what my ISP supplied me with ..

so now im trying to figure out if its my fault or thiers

many thx

They have: 101 posts

Joined: Apr 2003

i have a similar problem running commands as localhost.. access denied also, maby we are facign the same problem?

i mean i can't create a database using phpMyadmin but i can using my Cpannel.

Odd isnt it?

They have: 461 posts

Joined: Jul 2003

you need to have the host that contains the db to give you a usename an password. you don't connect to localhost (your computer you're at) but a remote host (the computer witht eh db) and then give that commands. all php my admin and other things like that do is obscure you from the cli. if you want to really be able to control the db statements you need to knwo the command line. heck you need to know it in using the php/asp/jsp/perl/whatever commands that interact with mysql, because you still need to give the column level commands

POSIX. because a stable os that doesn't have memory leaks and isn't buggy is always good.

They have: 101 posts

Joined: Apr 2003

guess the tutorial is for root users?

They have: 461 posts

Joined: Jul 2003

which tutorial are you talking about? most cover what you need to know to run it yourself before going on to anything else because it's helpful to know that so you can do your own backups when on someone else's server

POSIX. because a stable os that doesn't have memory leaks and isn't buggy is always good.

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.