my new host yay errr...erg mysql

[acid45]

Well I finally got a host for my site rather than "dust" on my computer. My cousin gave me some space on his domain he owns. He's not very computer savvy though. He can use a computer, program bad html and he knows what a function and variable are so I can't realy ask him for help.

Well I got my site loaded. I'm not going to bother with the url, nothing but green some pics and a bunch of mysql errors. This is because I haven't learnt how to connect to a sql server remotley. Easy right...well I must be a moron because I use

mysql --host=subdomain.domain.net --user=username password=password

and I get access denied to username@myip using password:yes I don't know wtf to do, I don't know who he is hosting with or anything.

anyone have any ideas on where I could look? I've submitted a proposal with this domain and they have been viewing a bunch of mysql errors for 5 days(proposal deadline) i bet they already trashed it :(


I'm doing the only thing I know how,m programming a php script to do all my sql managment :S this is going to be a long night!!!

tired and beat, this isn't going to be done in time :(

[klackenfus]

mysql --host=subdomain.domain.net --user=username password=password

Just a thought but have you verified that the MySQL username you are trying to log in with is authorized to log into MySQL? I know this might seem obvious but it could be something as simple as that.

[acid45]

Well if i use it in a script it works fine...my news page is up...

there were typos in my command line it was --password= not just password=

$link = mysql_connect('localhost:port', "user","pass" ) or die('Could not connect: ' . mysql_error());
mysql_select_db(database) or die('Could not select database');
this works

Also the script i used to make my news page doesn't work to create any other tables.

http://waynemarsh.ilovesamantha.net

also I don't play with headers in my index page, unless cookies are headers...that's what line 96 points to setcookie("Logged","1"); which has been removed and the error still exists

I have workarounds to all my problems. I put all set cookies to the top, I realized that's what default:{break;} was for...duh

I'm using scripts to add content, really I think it's easier, nothing like loops for entering images :P

[thaddaeus]

i might suggest doing some reformatting to the page so that links on the left stay on the top of the page not the middle, it would be cleaner. Are you useing css to format the page or useing <tables>

Makeing scripts is not a bad thing especially when useing php, for my webiste ReX Productions (http://rex-pro.com) i use scripts for every aspect of the page, i also use mysql heavily. Using mulitple files eases the process.

Also (I gotta think whole thoughts and stop editing my post) if you need some help with some codeing/design, pm me, most of the ReX Productions stuff was written by me.