Any1 uses phpMyAdmin
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 posted this at 22:12 — 7th August 2003.
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 posted this at 23:44 — 7th August 2003.
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!
starter posted this at 23:46 — 7th August 2003.
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 posted this at 10:27 — 8th August 2003.
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
starter posted this at 04:15 — 9th August 2003.
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 ,
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."
but im using what my ISP supplied me with ..
so now im trying to figure out if its my fault or thiers
many thx
mohd posted this at 22:17 — 13th August 2003.
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?
m3rajk posted this at 22:32 — 13th August 2003.
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.
mohd posted this at 22:35 — 13th August 2003.
They have: 101 posts
Joined: Apr 2003
guess the tutorial is for root users?
m3rajk posted this at 22:42 — 13th August 2003.
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.