Forum Moderators: phranque
All the open source programs have some of the worst help/documentation I've ever read. I'm not kidding.
"Download this simple program to administer your MySQL"...so I do...and it takes 16 hours to decipher the spelling errors etc. to only find out I'm STILL clueless...and it doesn't work. It would take longer to install the program than it....well you get the point.
Even my host's documentation is terrible....it didn't even work:
username@server% mysql -hdb14.myhost.com -uusername -p username_dbname
Enter password: <enter password here>
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.27-beta-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql>
And THAT's the SIMPLE way...
Any ideas?
I'm playing around with MySQL also, and using PHP to play around with it......after installing "PHP myAdmin" which is free and pretty easy to set up.
Maybe you might want to download and try a similar program. This particular one only asks to change a few lines of code to get it working (you only need to know where you installed it plus your mySQL username/password).
Then, maybe, after you have installed this you can work out exactly what you want to do with mySQL and anything else you want to know (like if it's installed on your host!) :)
I tried the above suggested program...I can't understand the intallation instructions.
MySQL is on my host...I was able to install a database via their GUI...you just can't do anything else with it..
did you get to the point where you had this prompt or is that blurb what they told you to do that didn't work?
username@server% mysql -hdb14.myhost.com -uusername -p username_dbname
//server replies as such
Enter password:
//you enter your password and, if correct, server welcomes you
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.27-beta-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql>
then you type at the prompt
ie.
show databases;
use somedb;
show tables;
select * from sometable where somefield='value';
etc
If you continue to pursue PHPmyAdmin (depending on if your server has PHP installed) then there are 3 bits you want to change in the config.inc.php file (in order of appearance)
$cfg['PmaAbsoluteUri'] = 'URL including / at the end';
$cfg['Servers'][$i]['user'] = 'mySQL username';
$cfg['Servers'][$i]['password'] = 'mySQL password';
Then load up the directory you uploaded to.
There will be other ways, this is just the way I got it up and running for myself.
I myself changed the 'myhost' portion to stay within the guidelines of this forum...
I've tried 3 different programs...none work...and they claim to be 'simple'.
username@server% mysql -hdb14.myhost.com -u username -p username_dbname
when I log into my server using securecrt and want to go into mysql, I type
mysql -u username -p <enter>
type password <enter>
so, that is a portion of the above line. The rest is the connecting part. I am not totally sure what you would change here because I don't know what server etc you use. I would call your host and have them send you the exact line to use in regards to your particular site. You would think they could do that. Or maybe they can walk you through it.
I dunno Scott, reading the documentation for my host, it says that localhost in my instance can be the only host mentioned due to "security issues". Hopefully someone else might be able to chip in if you choose to use phpmyadmin.
Though a quick email to your host should resolve that sort of prob...
Even my wife...who runs the entire network for our city thinks the documentation is garbage for this...
I e-mailed them almost 3 hours ago...I've yet to receive a response. The part that bothers me is that they have a 'tutorial'...and the tutorial is wrong...is doesn't work.
/frustration
PS-Gave up on Analog 5.22 after several hours (Read double digits of hours) wading through poor documentation. Spent the $99 on a commercial package ....worked in minutes. Still think Analog is over-rated for anyone new to programming...
I wish I could help more, I will watch this thread though and offer any further info I can gleen. I am used to setting up a new connection, typing in the host, username and password setting a few other params and off we go.
Haven't had this much trouble before but I also haven't worked with your host before. ;)
Yeah baby! /Austin Powers
Finally got an e-mail back from my host...it seems you need to log onto your server via telnet BEFORE you log into your database server. Nothing in the instructions about that...
Thanks guys for all the help!
