Trying to set up a database server in Ubuntu 4.10

[alfa147x]

So im trying to set up wordpress on my Ubuntu Machine
I used this tutorial:
http://www.jonathanmoeller.com/screed/?p=932&cpage=1


twesh@ubuntu:/home$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 55
Server version: 5.0.83-0ubuntu3 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE wordpress2;
Query OK, 1 row affected (0.08 sec)

mysql> CREATE USER wordpressuser2;
Query OK, 0 rows affected (0.07 sec)

mysql> SET PASSWORD FOR wordpressuser2 = PASSWORD(?password?);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?password?)' at line 1
mysql>


I can't figure out what i'm doing wrong! ugh

Any assistance is well appreciated

~Alfa

 

[n0cmonkey]

set password for 'wordpressuser2'@'localhost'=PASSWORD('password');

EDIT: BTW, be careful with wordpress. The security trackrecord is shite.

 

[alfa147x]

Originally posted by: n0cmonkey
set password for 'wordpressuser2'@'localhost'=PASSWORD('password');

EDIT: BTW, be careful with wordpress. The security trackrecord is shite.

Thanks for your help

but that the error that i get


twesh@ubuntu:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29
Server version: 5.0.83-0ubuntu3 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set password for 'wordpressuser2'@'localhost'=PASSWORD('password');
ERROR 1133 (42000): Can't find any matching row in the user table
mysql> CREATE USER wordpressuser2;
ERROR 1396 (HY000): Operation CREATE USER failed for 'wordpressuser2'@'%'
mysql> set password for 'wordpressuser2'@'localhost'=PASSWORD('password');
ERROR 1133 (42000): Can't find any matching row in the user table
mysql>

 

[Crusty]

I find using the GRANT syntax easier than using CREATE USER. For example, to create the database and a user that has FULL ACCESS to it you could do

CREATE DATABASE wordpress2;
GRANT ALL ON wordpress2.* TO 'wordpressuser2'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

To limit the permissions you would change ALL to a list of the permissions you want said user to have. http://dev.mysql.com/doc/refman/5.0/en/grant.html has a lot more information about what's possible using GRANT.

 

[Crusty]

BTW are you really using Ubuntu 4.10!? That's 5 years old and the original public release IIRC, I would highly recommend upgrading to the newest LTS version as there have been some significant security holes patched in that time.

The support period for Ubuntu 4.10 is now nearing its end, and Ubuntu 4.10 will officially reach end-of-life on April 30th, 2006. At that time, Ubuntu Security Notices will no longer include information or updated packages for Ubuntu 4.10.

 

[n0cmonkey]

Originally posted by: alfa147x

Originally posted by: n0cmonkey
set password for 'wordpressuser2'@'localhost'=PASSWORD('password');

EDIT: BTW, be careful with wordpress. The security trackrecord is shite.

Thanks for your help

but that the error that i get


twesh@ubuntu:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29
Server version: 5.0.83-0ubuntu3 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set password for 'wordpressuser2'@'localhost'=PASSWORD('password');
ERROR 1133 (42000): Can't find any matching row in the user table
mysql> CREATE USER wordpressuser2;
ERROR 1396 (HY000): Operation CREATE USER failed for 'wordpressuser2'@'%'
mysql> set password for 'wordpressuser2'@'localhost'=PASSWORD('password');
ERROR 1133 (42000): Can't find any matching row in the user table
mysql>

Then you're applying it to the wrong user. Figure out which user (use mysql; select * from user; --or something like that) to apply the password to.

 

[alfa147x]

Originally posted by: Crusty
BTW are you really using Ubuntu 4.10!? That's 5 years old and the original public release IIRC, I would highly recommend upgrading to the newest LTS version as there have been some significant security holes patched in that time.

The support period for Ubuntu 4.10 is now nearing its end, and Ubuntu 4.10 will officially reach end-of-life on April 30th, 2006. At that time, Ubuntu Security Notices will no longer include information or updated packages for Ubuntu 4.10.

Hahaha nice catch im using 9.10

Thanks

 

[alfa147x]

Originally posted by: Crusty
I find using the GRANT syntax easier than using CREATE USER. For example, to create the database and a user that has FULL ACCESS to it you could do

CREATE DATABASE wordpress2;
GRANT ALL ON wordpress2.* TO 'wordpressuser2'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

To limit the permissions you would change ALL to a list of the permissions you want said user to have. http://dev.mysql.com/doc/refman/5.0/en/grant.html has a lot more information about what's possible using GRANT.

THANKS A WHOLE BUNCH!
But i accidentally set the password to password... good thing this is just a test server