For those of you who really know how to use this abominable piece of thing, please reply. I have never used MySQL before, so anything that online tutorials say mean little to nothing to me. My knowledge of HTML is limited to text formatting (i.e. bold, italic, underline), making hyperlinks, and making tables. I installed MySQL 4.0 on an XP system. I've been given the database's name, its user login, and its password. I have something called a MySQL command line, but I have no idea how to use it to connect to a database. At all. I do, however, have a basic FTP client, and have no idea how to use it to access the MySQL thing. I also have no idea how to modify data on a MySQL database, let alone access it. If someone is patient enough to explain things in as simple English terms as possible, that would be great.
hmmph its been a long long time since i last touched mysql so i'm sure its a newer version etc but u shouldn't need anything to do with ftp generalising u need the server installed (preferably locally) then theres the gui/ide that connects to the server (which is local) use the gui/ide to do all ur modifications etc i'll haf a look at it again wen i get some time gotta finish off my work >.<
i have never used mysql before; have always used ORacle. anyways, there's a free tool on Oracle site ... http://www.oracle.com/technology/getting-started/sqldev.html that I believe allows you to connect to MySql db as well. I think there are limitations; but you should be able to see the table, query some data, append date, etc.
Start by getting yourself familiar with the basics. Try getting a beginners guide on google,eg: http://www.devshed.com/c/a/MySQL/Beginning-MySQL-Tutorial/
sorry if I didn't elaborate. 1) the server is not local. 2) I don't have a choice of oracle or mysql. the site is being updated with a hybrid of php and mysql. 3) I know the login information for the database, but for some reason I can't connect to it via the mysql command line client that was installed with the software.
