MySQL - GoFuckYourself.com

Tiffany Roxxx · 01-23-2005, 10:13 PM

I'm trying to install a MySQL db, its there, shows as being installed...but I cant get to it lol.
it says "You can use phpMyAdmin to administrate your MySQL databases in a web based environment. "
when I click the link "phpMyAdmin" it tells me "You are logged in with the root, or reseller's password" (Im logged into the control pannel...Im not sure what it means by resellers password...maybe I dont have the proper password to access the db? but it let me install the db...)

Im a bit lost...never used this and needed to install it for a script
any Ideas?

NaughtyRob · 01-23-2005, 10:16 PM

You need to ask your host.

ytcracker · 01-23-2005, 10:16 PM

im sorry but youre pretty

Tiffany Roxxx · 01-23-2005, 10:25 PM

Thanks, I kinda figure'd its not soemthing I could change, tried a few things with no luck, I'll ask my host in the morning

ty ytcracker

calmlikeabomb · 01-24-2005, 12:36 AM

Login to your server via ssh. Change directories to where mysql is installed and login to the mysql server.

Will be something like this:

[calmlikeabomb@reviews]# cd /usr/bin/
[calmlikeabomb@reviews]# mysql -u root -p -h your.server

Where -u is the user logging in (root in this example), -p just specifys we will be using a password, -h is the server were logging in to. Then you will be promted for the mysql password that is associated with the user.

After logging in Select a database to work with:

mysql> use databasename;

If you don't know what databases are in the system:

mysql> show databases;

Show the tables in a database once you've selected one:

mysql> show tables;

Learn more about the fields/columns that the table consists of:

mysql> describe sometable;

Hope this gets you headed in the right direction ; )

fris · 01-24-2005, 01:11 AM

Quote:

Originally Posted by calmlikeabomb

Login to your server via ssh. Change directories to where mysql is installed and login to the mysql server.

Will be something like this:

[calmlikeabomb@reviews]# cd /usr/bin/
[calmlikeabomb@reviews]# mysql -u root -p -h your.server

Where -u is the user logging in (root in this example), -p just specifys we will be using a password, -h is the server were logging in to. Then you will be promted for the mysql password that is associated with the user.

After logging in Select a database to work with:

mysql> use databasename;

If you don't know what databases are in the system:

mysql> show databases;

Show the tables in a database once you've selected one:

mysql> show tables;

Learn more about the fields/columns that the table consists of:

mysql> describe sometable;

Hope this gets you headed in the right direction ; )

please tell her in english

she will need to use to database with the software.

tiffany if the software you are using needs say "database1" and the user and pass thats what you put when you install the software, the actual software accesss it.

phpmyadmin is web based software used to edit your database that your host will setup.

what software are you trying to install?

01-23-2005, 10:13 PM	#1
Tiffany Roxxx Registered User Join Date: Aug 2003 Posts: 87	MySQL I'm trying to install a MySQL db, its there, shows as being installed...but I cant get to it lol. it says "You can use phpMyAdmin to administrate your MySQL databases in a web based environment. " when I click the link "phpMyAdmin" it tells me "You are logged in with the root, or reseller's password" (Im logged into the control pannel...Im not sure what it means by resellers password...maybe I dont have the proper password to access the db? but it let me install the db...) Im a bit lost...never used this and needed to install it for a script any Ideas?

01-23-2005, 10:16 PM	#2
NaughtyRob Two fresh affiliate progs Industry Role: Join Date: Nov 2004 Location: Inside teen pussy Posts: 29,602	You need to ask your host. __________________ [email protected] Skype: 17026955414 Vacares Web Hosting - Protect Your Ass with Included Daily Backups

01-23-2005, 10:16 PM	#3
ytcracker stc is the greatest Join Date: Dec 2002 Location: rip sean murray Posts: 12,403	im sorry but youre pretty __________________ www.ytcracker.com \| www.digitalgangster.com i love you

01-24-2005, 12:36 AM	#5
calmlikeabomb Confirmed User Join Date: May 2004 Location: SW Palm Bay, Florida Posts: 1,323	Login to your server via ssh. Change directories to where mysql is installed and login to the mysql server. Will be something like this: [calmlikeabomb@reviews]# cd /usr/bin/ [calmlikeabomb@reviews]# mysql -u root -p -h your.server Where -u is the user logging in (root in this example), -p just specifys we will be using a password, -h is the server were logging in to. Then you will be promted for the mysql password that is associated with the user. After logging in Select a database to work with: mysql> use databasename; If you don't know what databases are in the system: mysql> show databases; Show the tables in a database once you've selected one: mysql> show tables; Learn more about the fields/columns that the table consists of: mysql> describe sometable; Hope this gets you headed in the right direction ; ) __________________ subarus. Last edited by calmlikeabomb; 01-24-2005 at 12:37 AM..

01-23-2005, 10:25 PM	#4
Tiffany Roxxx Registered User Join Date: Aug 2003 Posts: 87	Thanks, I kinda figure'd its not soemthing I could change, tried a few things with no luck, I'll ask my host in the morning ty ytcracker