mySQL problem?

[Tomm]

MySQL command line tool.

(Login via Remote Desktop, Start > Programs > MySQL > MySQL command line)

Yer ino but where?

[Galaxay1]

ok on it and typed

SET PASSWORD FOR 'localhost'@'localhost' = OLD_PASSWORD('newpwd');

then it comes up with

ERROR 1133 (42000): Can't find any matching row in the user table

:S

[Galaxay1]

Ok finally got it to do it but still get the same error? :S

[Tomm]

You need to replace the user with the user you are trying to log into MySQL with and host with the host that you are trying to connect with. Also replace newpwd with a new password, or you can use your old one.

E.g if I was logging in with "user1" with password "3r5gf5" from localhost I would use:

SET PASSWORD FOR 'user1'@'localhost' = OLD_PASSWORD('3r5gf5');

Also after that if you are still having problems type:

FLUSH PRIVILEGES;

This forces MySQL to reload user and permission data.

[Galaxay1]

WOOT It works i love you

[Galaxay1]

Cant edit above but now, how can i make it so the stuff can write to my computer?
Its Server 2003

Cause im trying to get it so i can make databases and such and anyone got a *copy* of plesk

[Tomm]

Use the SQL above, but replace the localhost with %

Why not buy plesk? I am sure your VPS/Server hosting provider can provide you with a cheap license.

Cant edit above but now, how can i make it so the stuff can write to my computer?
Its Server 2003

Cause im trying to get it so i can make databases and such and anyone got a *copy* of plesk

[Galaxay1]

k but with the writable like, if im using a vBulletin, how do i set it so some files are writable? And how do i make a database ? So i can set vb to run from the username / pass / name.

[Tomm]

You don't need to. Windows is not like Linux where you need to make stuff writable. By default the Apache server starts under Network Service or System.

You can use the MySQL command line to create databases, however is is much easier to use a tool like phpMyAdmin. Or if you want a nice windows application that you can run on your PC I recommend Navicat (If you need help acquiring a copy just PM me ).

k but with the writable like, if im using a vBulletin, how do i set it so some files are writable? And how do i make a database ? So i can set vb to run from the username / pass / name.

[Galaxay1]

I installed phpMyAdmin in the htdocs folder, then went to /scripts/setup.php and get:

Can not load or save configuration
Please create web server writable folder config in phpMyAdmin toplevel directory as described in documentation. Otherwise you will be only able to download or display it.


Not secure connection
You are not using secure connection, all data (including sensitive, like passwords) are transfered unencrypted! If your server is also configured to accept HTTPS request follow this link to use secure connection.