Mysql Connection Error :(

[I.am]

Sorry wasnt here! Have to jump every now and then in the real life

Yes use your Control Panel to create a database. You cannot create tables with just codes...

You can also use ssh to login the server and create it but why take the hassle when you have the easier option.

No one will ask you to create a database with code. You have to create using your own control panel and then you can link it wherever you need it.

[TRshady]

oh ok thanks.
Thing is though, I have a few e-books on mysql and they all teach you the coding ..... which is uneeded right as I'll be using phpmyadmin.

So are there any books out that teach you the .... phpmyadmin way of using dbs, of course both methods get the same results but things would be easier if the book simply told the control panel way.

Thanks for you help so far.

[I.am]

I have never read books in my life for webdesigning or development Self made developer I guess. But more towards online learning. I am sure if you search for that on google you will see some useful results. Thats where I always go. phpmyadmin is not that hard. Give it a go!

Even with the book you have for mysql follow it and you will be ok with the coding(commands) part too.

You just have to take your own time ti learn.

[TRshady]

k, thanks.
But if I did want to put the code in and follow some of these example, wheres the command promt type box or something I could type the codes in?

[I.am]

Originally posted by TRshady@17 December 2003 - 13:36
k, thanks.
But if I did want to put the code in and follow some of these example, wheres the command promt type box or something I could type the codes in?

You have to connect to your host through ssh or putty. Once logged in the unix server where mysql is installed, you can do all that part of creating databases, tables etc.

[Ynhockey]

You cannot create tables with just codes...

Not true. Example:

$resource = mysql_query("CREATE TABLE users (name varchar(32), pass varchar(16));");

Would work.

Source: http://sqlcourse.com/create.html

You can also create databases, like mysql_create_db($database_name); but most likely the server will kick you back with an Access Denied error.

[I.am]

@Ynhockey, Thanks for bringing that up. I wasn't quite aware of that. I always used to login through ssh to my host and create database, tables etc. through that.

Never needed to create tables right on the page when the user required. This could be helpful in the future.

[Ynhockey]

This thing is very helpful for making something like a 'create a page' option in your CMS. Usually you'd want it to create a file but often circumstances don't allow that (if your CHMOD is set to prohibit writing files... but if you CHMOD to allow it then someone could easily hack you), so you can just create a new entry in the database in the form of a table. This is not always necessary but IMO it's the best way.

[I.am]

It surely is unsecured if the writing permissions are given to the user. Simple code can be run in php and asp for the very same reason and thus the permissions are set to 755.

But could be helpful if you already authenticate the user and let him/her store things as required.