Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By promete on
I installed apache php Mysql on Wİndows XP. I copied Drupal folder under htdocs. When it creating database connection and creating users for drupal in Mysql command line, i failed.
I write " mysqladmin -u dba_user -p create drupal ". According to handbook; it asks for password. but nothing happens. another line comes. Then I write;
"mysql -u dba_user -p " . nothing happens again. Then
"GRANT ALL PRIVILEGES ON drupal.*
TO nobody@localhost IDENTIFIED BY 'password';"
But it gives an error message . The follwing is the mysql command line screen:
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.13-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> mysqladmin -u dba_user -p create drupal
-> mysql -u dba_user -p
-> GRANT ALL PRIVILEGES ON drupal.*
-> TO nobody@localhost IDENTIFIED BY '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 'mysql
admin -u dba_user -p create drupal
mysql -u dba_user -p
GRANT ALL PRIVILEGE' at line 1
mysql>
What is the problem? What should I do? İ am getting crazy.....
Comments
use PHPMYadmin
PHPMYADMIN is an open source free tool to use the MYSQL server through explorer and easy to use configure and installation of phpmyadmin is very easy.
http://www.phpmyadmin.net/home_page/
An effective mysql management.
Through this u can create, upload and install databases and it's very simple.
Sunny
www.gleez.com
mysql on windows
Hi. To create a database, you don't need the command mysqladmin after you are in the mysql command line. You do:
your_prompt>mysql -u your_user -pyour_password
mysql>create database xxx;
you should receive a line starting with "Query OK"
phpMyAdmin is imho very good; you can also use "MySQL Query Browser" and "MySQLAdministrator"; both programs can be downloaded from the mysql site I think.
index page
I opened the database.mysql file and copied all then pasted it to the query browser. I created dbase. But now when I opened index page, I couldn't create admin account. It redirects to localhost main page. Help please
Virtual Host?
Maybe you need to declare a virtual host in your httpd.conf. See:
http://drupal.org/node/30908
If it is a local test site like local.mysite.com, you also have to add this site to the file
C:\WINDOWS\system32\drivers\etc\hosts
by adding the line:
127.0.0.1 local.mysite.com
virtual host
Thank you but nor it says:
unable to select database . i am getting crazy
select database
Where do you get this error? Did you already edit your sites\default\settings.php (4.6.x) or includes\conf.php (4.5.x) file?
settings
I made changes for dbase.
$db_url .... etc.
When i typed " http://localhost" it says unable to select database.
$base_url
What is the name of your $base_url? localhost? Post here your $db_url with a fake login and pwd as well.
$base_url
$db_url = 'mysql://dba_user:123456@localhost/drupal';
$db_prefix = '';
/**
* Base URL:
*
* The URL of your website's main page. It is not allowed to have
* a trailing slash; Drupal will add it for you.
*/
$base_url = 'http://localhost';
database name
your database name should be "drupal"; if the database name does not exist, you'll get the message "unable to select database". In your MySQL Query Browser, you should get a list of all your databases on the right under "Schemata" (version 1.1.3). Do you see a database named "drupal" there? If not, the database does not exist yet.
I solved it but now
Weird things happen to me. I solved it but now i faced another problem. I want to create first account . So it will be admin. But when i clicked create first account on index page, it directs to localhost. And lists the folders and files exists in localhost. Then i click index.php again but it gives another error . Something like "Second query 1 ..." . When i empty sessions table i solved it. But it happens again.
now everything normal but the first problem continues. it redirects localhost. There is just one site on my localhost . So there is no need to virtula host.Am i wrong?
PS : The explorer bar shows: http://localhost/?q=user/register
when i clicked create first account
Just try it
Just try it like in http://drupal.org/node/30908
Thanks
I solve it but now i got an smtp error
Install a mail server
Hi,
You need to install a mail server. ex;mercury mail (free), meerak mail servers.
Sunny
www.gleez.com