Mysql Step-by-step Please?

[Joshthegreat 0]

Please could someone tell me how to install queries and other basic requirements of MySQL so I can follow some of the members system tutorials in the tutorial forum. I'd be very gratefull if you coulf, because at the moment I'm pretty much stuck. Thanks.

[mobious 0]

Please could someone tell me how to install queries and other basic requirements of MySQL so I can follow some of the members system tutorials in the tutorial forum. I'd be very gratefull if you coulf, because at the moment I'm pretty much stuck. Thanks.

68494[/snapback]

what do you mean by installing queries? could you rephrase your post?

[mizako 0]

I suppose you want to install PHP/MySQL and Apache?

If i am right, the easiest way is to visit: https://www.apachefriends.org/index.html

[Joshthegreat 0]

Well in the MySQL members system tutorials it says SQL Queries, where do I type them in and how do I make sure everything works, I'm completely new to MySQL.

[mobious 0]

Well in the MySQL members system tutorials it says SQL Queries, where do I type them in and how do I make sure everything works, I'm completely new to MySQL.

68629[/snapback]

if your are using mysql through php then you will be executing the queries through the function mysql_query(). otherwise if you are using it directly inside a shell or command prompt in your own system then you should enter the mysql shell then execute the query directly.

[Joshthegreat 0]

I have no idea what pretty much all of what you said meant... perhaps I'll search for a step by step tutorial on google, maybe I could find a nice site that'll suit my needs. Thanks anyways.

[mobious 0]

what i meant was that if the mysql server was on a remote server then you can use PHP to connect to it and execute queries. but if it is hosted on a local server and you have access to it then you can just type the query in the shell(interpreter) of the server.

[Joshthegreat 0]

I'm using a Xisto host if that helps? Because I don't really know about servers and all of that stuff. I just know html and very little php.So, if you're using Xisto too, and are good at this sort of thing please help me! I really am in need of it.

[mobious 0]

I'm using a Xisto host if that helps? Because I don't really know about servers and all of that stuff. I just know html and very little php.

So, if you're using Xisto too, and are good at this sort of thing please help me! I really am in need of it.

68922[/snapback]

since you are hosted on Xisto, just use PHP to execute your MySQL queries. please try searching the forum for tutorials first. if there are none, just reply here and i will help you.

[badinfluence 0]

holla ya,
i dun wanna create new topic... me too.. i also finding step by step tutorial to approach MySql.. i've found some up to now.. here is the idea of MySql connection but still need to some more tutorials.. like how to create table and setting parameters according to what we need, concept between php and apache server, etc.. providing with some practical tutorials will be the best.. so that i can test out on going....

thks and appreciate,

p.s..i can sucessfully figure and run my system with Unix OSX Terminal, apache2,MySql,PHP,phpmyadmin,Cocoasql,sqladministrator,phpstar...somemore????

[nickmealey 0]

OK, I'm not sure if I have this right. But I'm going for it anyway. Now, I'm new to this to, keep that in mind. Go to command prompt (if you have MySql fully installed) > type:

mysql -h [I]your host name, like niclbee.trap17.com[/I] -u [I]your username[/I] -p

then it should show this:

enter password:

type your password, if it doesn't log you in, you've inserted the wrong hostname, user, or password. The next step is to create your database, go into your cpanel (yourdomain/cpanel) and click on the link for MySql databases, now type the name of the database and hit create database. Now, it always puts your username in front of the database name, like Josh_yourdatabase. Now, go back into command prompt and type:

use Josh_yourdatabase;

keep in mind that all statments must end with a ; . Now, it should display somthing like this:

mysql> use Josh_yourdatabase;database changedmysql>

this is where you type your query. type it and it should display exactly what went on. Hope that helped, if not, oppps...
PS: somone correct me if I made a mistake

nickmealey