pouët.net

It works :)
Thanks a lot!

Hooray. Sorry for the delay on fixing this.

Hi,

I have a question: exactly, how can I access mySql db? Is the password is same as for ftp? I can connect to database without password.
I've tried everything what came to my mind, but without success. In my script mysql_select_db() fails, but I have no rights to create a schema.

Thanks.

thank you, scamp. works fine now :)

bump

@martin: If you're able to connect to the local MySQL as root, simply administer your own users.
1: mysql
2: use mysql
3: select * from user

There's your complete table of allowed users. To "create" a new user, simply create a new database (if you don't have an existing one) and then do a "grant all privileges to <username>@localhost identified by '<password>' and the user will be added to your list of allowed users. And might I suggest you use PDO to access your data from PHP. It's really a more intuitive way to serve your data and there's a bunch of object-relation models that makes data-management really easy. I'd stay away from the really large ones since they may be a bit tricky and confusing at first sight. Instead, use something really simple as for example Uteeni - it's as simple as these 10 steps:

1: Create a new table using your preferred mysql client (let's call the table 'Example')
2: cd to where you put the uteeni-folder
3: php class_builder.php
4: Answer the prompt (1 for MySQL)
5: Enter name of the table (Example)
6: Edit your php document
7: require_once(class_loader.php) (the uteeni generic class-loader)
8: $ex = new Example();
9: $ex->test_property = "some string"
10: $ex->save();

To retrieve and manipulate the data you just stored:
$ex = new Example();
$ex->find_by_test_property("some string");
$ex->test_property = "another string";
$ex->save();

It's really basic and will save you hours of agony typing all those mysql-statements. It's lightweight and doesn't require shitload of configuration. requires PDO, though.

Darn - wrong grant-statement. It should be:
grant all privileges on <databasename>.<tablename or *> to <username>@localhost identified by '<password>'

Sorry about that.

hey punqtured, do you think he has root access to the shared mysql installation? :)

Yeah, I just saw that the minute after I posted it ;-)

@Punqtured:

Thank you very much for your help.
I will try Uteeni, sounds interesting. I have used ORM tools in Java, like Hibernate.

And i forgot to mention, that i can't create a database on untergrund, because i have no rights for it. mysql_connect() is successful with my username. So i can connect, but i don't know what to do next.

Can you please help me this?

martin: have you looked in phpmyadmin? You should have a database with the same name as your username.

gasman: thanks, i didn't know that phpMyAdmin exists on untergrund.
But sadly I can't log in. Tried to use the untergrund credentials, but no success.

Hopefully you have kept your untergrund.net account registration mail, because all the required information should be in there.

@Saga Musix: yes, i kept it. Bud i don't know if i requested mysql access or not back then. But i can't log in with phpmyadmin, so maybe the problem is, that i have't requested a mysql account.

martin: Drop me a mail with your account name from the mail you registered with and I'll enable a mysql account for you.

scamp: mail sent.
Thank you very much.

Bump!

Is there a problem with the ftp server for untergrund.net at the moment?

All the download links to the prods on my website that are served from there are broken and I can't upload to my directory on the ftp server either :(

what's the status on the FTP server? i keep getting password dialogs on public downloads.

same here

I have the problem with FTP too, people keep poking me about broken downloads.

I have the same problem. All my public links are now useless. :/

So, any updates on that issue?

Me too. Has anybody mailed scamp about it yet?