Help to install wordpress

ding76uk

ding76uk

Suspended / Banned
Messages
4,096
Name
Carl
Edit My Images
Yes
HI.

I am trying to install wordpress to my site. I am having a nightmare. I use a my sql client. But have copied the code of the 5 minute install thing, but it will nto work no matter what I do. I am going mad here.

Please someone give me a pointer.

The code I paste in is

$ mysql -u adminusername -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5340 to server version: 3.23.54

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE DATABASE databasename;
Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON databasename.* TO "wordpressusername"@"hostname"
-> IDENTIFIED BY "password";
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

mysql> EXIT
Bye
$

Can someone please baby step me through this please, as I am going mad!
 
Have you uploaded the Wordpress files to your server, using an FTP client?
 
Sorry, yeah, you need to set up a database. I'm not entirely sure what it is you're trying to explain in your first post. Have you set up a database, or is that what your first question is about?
 
Ah, ok. I get it now. You're using shell to set up the database. Unfortunately I didn't go that route to set up my own Wordpress. I've always used my the control panel provided by my host to creates my databases. I shall bow out. Apologies.
 
I've haven't done and SQL since uni, but are you sure that you have got a database to communicate with. Have you got PHPMyAdmin set up on your server?
 
Here's a suggestion:

Get a hosting account at www.tsohost.co.uk (they are brilliant).
Sign up using the code 'SCRAPPAGE' and you'll get one year's hosting for £7.50
Use their simple Wordpress install feature and you'll be blogging within moments.

(Obviously you'll need to move your domain or have a new one)
 
My hosting offered the service of installing wordpress for me, might be worth asking your host if they offer it too?
 
and are you litterally pasting this whole lot in?

$ mysql -u adminusername -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5340 to server version: 3.23.54

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE DATABASE databasename;
Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON databasename.* TO "wordpressusername"@"hostname"
-> IDENTIFIED BY "password";
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

mysql> EXIT
Bye
$
Click to expand...

cos it looks like there are 4-5 separate commands in there
 
#1064 - 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 '$ mysql -u username -p
Enter password:password:
Welcome to the MySQL monito' at line 1

The red bits I have replaced as these are my username and password for it.

Reall starting to annoy me now!
 
Carl,

a couple of things spring to mind.

I presume you are able to logon to the sql server as root?
the command would be something like "mysql -u root -p"

Then you would be prompted for the root password.

Once you have done that do a "show databases;" which will list all of the databases known to the server. - for example:

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| database |
| databasename|
| mysql |
+--------------------+
4 rows in set (0.02 sec)




One stumbling block is that each mysql command needs to be terminated with a semicolon,otherwise all you get back is a ">" prompt.

if databasename exists, try the command "use databasename;" and then try "show tables;"

This will tell you whether you have access to the database as root and whether any tables have been created.


Try typing in each command and seeing what the output is before moving on to the next.

The commands/responses that you posted in your original post - are they from your server or from the WP documentation? The reason i ask is that the version of mysql is quite old - I'm running 5.0.67 on my ubuntu server.

Finally, do you have access to a graphical tool such as mysqladministator or phpmyadmin? They make the whole thing much easier.
Once the database is created, installing wordpress is literally a five minute job. Honest!

Hope this helps.

Cheers

Mark
 
ding76uk said:
#1064 - 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 '$ mysql -u username -p
Enter password:password:
Welcome to the MySQL monito' at line 1

The red bits I have replaced as these are my username and password for it.

Reall starting to annoy me now!
Click to expand...

Looks like you're pasting the whole lot in. No wonder it's throwing a bit of a wobbly...:(

Try typing in each line one at a time. The "$" denotes the shell prompt (for a unix/linux system).

Type in "mysql -u your user name -p"

Mysql will then display "Enter Password", so type in your password.

Then, enter each command one at a time, namely:
CREATE DATABASE databasename;

GRANT ALL PRIVILEGES ON databasename.* TO "wordpressusername"@"localhost" IDENTIFIED BY "password";

Notice I've change "hostname" to "localhost", as it's the most likely value for hostname. Notice also that "password" needs to be be password for the wordpress user in the database.

FLUSH PRIVILEGES;

Hopefully, this will enable you to make progress.

Cheers


Mark
 
from what I remember during a wordpress install you don't need to use the shell to modify the mysql database at all.

The variables you are setting (data base name, user name and password) should all go in your wp-config file and then upload (via FTP) to your hosting. Assuming the database is set-up you should be able to install using the scripts provided, and there should be no modifications to those scripts besides those on wp-config.

Doesn't your hosting offer offer click install for wordpress anyway - alot do now?

Hugh
 
kiasdad said:
Looks like you're pasting the whole lot in. No wonder it's throwing a bit of a wobbly...:(

Try typing in each line one at a time. The "$" denotes the shell prompt (for a unix/linux system).

Type in "mysql -u your user name -p"

Mysql will then display "Enter Password", so type in your password.

Then, enter each command one at a time, namely:
CREATE DATABASE databasename;

GRANT ALL PRIVILEGES ON databasename.* TO "wordpressusername"@"localhost" IDENTIFIED BY "password";

Notice I've change "hostname" to "localhost", as it's the most likely value for hostname. Notice also that "password" needs to be be password for the wordpress user in the database.

FLUSH PRIVILEGES;

Hopefully, this will enable you to make progress.

Cheers


Mark
Click to expand...

Will give this a try, yeah I threw it in all at once, I have no idea on all this stuff, so am feeling my way through very gingerly.
 
can i also suggest you edit the config file in notepad and not an editor. i used to have a prob with a few blank lines at the bottom after the code which editors made. backspace them in notepad and save

no idea why this affected any thing but it did.
 
You must log in or register to reply here.
Back
Top