I tried installing wordpress with this how to:
But when i go to:http://bubba/wordpress/wp-admin/install.phpHow to Install WordPress On Debian Etch
Complete the following the steps:
1. # apt-get install wordpress
2. # mysql -u root
3. mysql> CREATE DATABASE wordpress
4. mysql> GRANT ALL PRIVILEGES ON *.* TO wordpress@localhost
IDENTIFIED BY ‘wordpresspassword’ WITH GRANT OPTION;
5. mysql> FLUSH PRIVILEGES;
6. #mv wp-config-sample.php wp-config.php
7. Edit wp-config.php to enter the correct setting:
// ** MySQL settings ** //
define('DB_NAME', 'wordpress');
define('DB_USER', 'wordpress');
define('DB_PASSWORD', 'wordpresspassword');
define('DB_HOST', 'localhost');
8. Add to /etc/apache2/sites-available/default:
Alias /blog "/usr/share/wordpress/"
<Directory "/usr/share/wordpress/">
Options FollowSymLinks
AllowOverride Limit Options FileInfo
DirectoryIndex index.php
</Directory>
9. #/etc/init.d/apache2 restart
10. Goto: http://localhost/blog/wp-admin/install.php
11. Follow the instruction to create a login
12. Use generated login to log in and start blogging.
I get the error:
any idea how to fix this?
Can’t select database
We were able to connect to the database server (which means your username and password is okay) but not able to select the wordpress database.
Are you sure it exists?
On some systems the name of your database is prefixed with your username, so it would be like username_wordpress. Could that be the problem?
If you don't know how to setup a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.
i already tried to check the database in mysql and i get:
thanks,mysql> CREATE DATABASE wordpress ;
ERROR 1007 (HY000): Can't create database 'wordpress'; database exists
mysql> \q
Rewien