Installing MySQL

[tomyknoker]

Hi All,

I have always just had MySQL on servers I have dealt with, so I've logged into the web host control panel and have been able to add users and databases from there, either on the hosts control panel or by PHPMyAdmin. On the particular server I am working with, the server is housed on the premises. So they don't really have a control panel all they have given me are the details for InstaGate EX... Any ideas how I can use this to:

a) See if MySQL is on the system
b) Add databases to it

[scoutt]

just install phpmyadmin?

to find out if it is installed load phpinfo() to find out


<?php
phpinfo();
?>


in that list it will show mysql if it is installed.

[tomyknoker]

Hi Scoutt! Yay well that worked! It said PHP Version 4.4.3

So now should I install PHPMyAdmin? How do I found out what the MySQL main username and password is? Would there be one do you think?

[scoutt]

actually, your host has to give that to you. in order to install phpmyadmin you have to have that info. you also have to have the database name. I would email them.

[tomyknoker]

Ah ok well I think I'm stuck then... It's a friends server, actually housed in there building. The only info they can give me is something to login to InstaGate... From here I can see a few settings, but nothing major...

[scoutt]

why can't he create you the mysql database and user and password? it is not hard if it is their server.

[Paul]

You can also try the username root with no password. If you have root access to the server this might work if no password was set, but the best option is to setup a username and password. Do you have SSH access to the server?

[RogerRamjet]

Forget phpmyadmin, go get the mysql development tools (http://www.mysql.com/products/tools/). You will just need a login for the mysql server to do what you need. The tools install on your local machine so you don't need root access to the server.

[scoutt]

if he had the login then he wouldn't need the mysql tools. that is the whole point of getting the login info form his host. it is not local and he doesn't have it.

[RogerRamjet]

He must have a db login for his scripts to use - and also for phpmyadmin to use. That is not the same as a UNIX/LINUX system login, and very far from having a superuser root login. He will need server admin privileges to install and configure phpmyadmin, and only a fool of a server admin is going to hand that out to all and sundrey.

Provided his db login has create table privileges then all he needs are the mysql admin tools. Be even better if he had a db admin user with access to the users privilege system and create db privileges, but not neccessary once a db and assocaited user account have been created. Given the db login that his scripts must have to access the db, he can use the mysql tools installed on his local machine to do everything that phpmyadmin can do plus much more that it cannot do.

Phpmyadmin was great for the past 5 years but with the advent of mysql tools it has been superceded and is redundant.

[scoutt]

phpmyadmin does not need admin/root access. it is just a script any user can setup.

Also he said this

How do I found out what the MySQL main username and password is?

So apparently he doesn't know mysql login info.