GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   MySQL (https://gfy.com/showthread.php?t=421221)

Tiffany Roxxx 01-23-2005 10:13 PM

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?

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 :angel

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?


All times are GMT -7. The time now is 05:17 AM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123