|
|
Mysql2::Error: Can't create database
Hi all
database yml------
development:
adapter: mysql2
database: db_test
username: root
password:
------------------
i have installed mysql2 and 64bit mysql server.
when i run rake db:create it gives me this errror
does any one know whats happening here?
macbook:test_proj rathod$ rake db:create --trace
(in /Users/rathod/Desktop/test_proj)
** Invoke db:create (first_time)
** Invoke db:load_config (first_time)
** Invoke rails_env (first_time)
** Execute rails_env
** Execute db:load_config
** Execute db:create
rake aborted!
Mysql2::Error: Can't create database 'db_database' (errno: 2): CREATE
DATABASE `db_database` DEFAULT CHARACTER SET `utf8` COLLATE
`utf8_unicode_ci`
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.5/lib/active_record/connection_adapters/abstract_adapter.rb:207:in
`rescue in log'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.5/lib/active_record/connection_adapters/abstract_adapter.rb:199:in
`log'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/mysql2-0.2.6/lib/active_record/connection_adapters/mysql2_adapter.rb:314:in
`execute'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/mysql2-0.2.6/lib/active_record/connection_adapters/mysql2_adapter.rb:406:in
`create_database'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.5/lib/active_record/railties/databases.rake:68:in
`rescue in create_database'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.5/lib/active_record/railties/databases.rake:39:in
`create_database'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.5/lib/active_record/railties/databases.rake:35:in
`block (2 levels) in <top (required)>'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:636:in
`call'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:636:in
`block in execute'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:631:in
`each'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:631:in
`execute'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:597:in
`block in invoke_with_call_chain'
/Users/rathod/.rvm/rubies/ruby-1.9.2-p180/lib/ruby/1.9.1/monitor.rb:201:in
`mon_synchronize'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:590:in
`invoke_with_call_chain'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:583:in
`invoke'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2051:in
`invoke_task'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2029:in
`block (2 levels) in top_level'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2029:in
`each'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2029:in
`block in top_level'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2068:in
`standard_exception_handling'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2023:in
`top_level'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2001:in
`block in run'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2068:in
`standard_exception_handling'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:1998:in
`run'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/bin/rake:31:in
`<top (required)>'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/bin/rake:19:in `load'
/Users/rathod/.rvm/gems/ruby-1.9.2-p180/bin/rake:19:in `<main>'
--
Posted via http://www.ruby-forum.com/.
|
|
0
|
|
|
|
Reply
|
 Rajesh
|
3/25/2011 5:18:15 PM |
|
[Note: parts of this message were removed to make it a legal post.]
Do you really have no password on the root account for your MySQL install?
On Fri, Mar 25, 2011 at 6:18 PM, Rajesh B. <rajesh.13kits@gmail.com> wrote:
> Hi all
>
>
> database yml------
>
> development:
> adapter: mysql2
> database: db_test
> username: root
> password:
> ------------------
>
> i have installed mysql2 and 64bit mysql server.
> when i run rake db:create it gives me this errror
>
> does any one know whats happening here?
>
>
> macbook:test_proj rathod$ rake db:create --trace
> (in /Users/rathod/Desktop/test_proj)
> ** Invoke db:create (first_time)
> ** Invoke db:load_config (first_time)
> ** Invoke rails_env (first_time)
> ** Execute rails_env
> ** Execute db:load_config
> ** Execute db:create
> rake aborted!
> Mysql2::Error: Can't create database 'db_database' (errno: 2): CREATE
> DATABASE `db_database` DEFAULT CHARACTER SET `utf8` COLLATE
> `utf8_unicode_ci`
>
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.5/lib/active_record/connection_adapters/abstract_adapter.rb:207:in
> `rescue in log'
>
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.5/lib/active_record/connection_adapters/abstract_adapter.rb:199:in
> `log'
>
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/mysql2-0.2.6/lib/active_record/connection_adapters/mysql2_adapter.rb:314:in
> `execute'
>
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/mysql2-0.2.6/lib/active_record/connection_adapters/mysql2_adapter.rb:406:in
> `create_database'
>
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.5/lib/active_record/railties/databases.rake:68:in
> `rescue in create_database'
>
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.5/lib/active_record/railties/databases.rake:39:in
> `create_database'
>
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/activerecord-3.0.5/lib/active_record/railties/databases.rake:35:in
> `block (2 levels) in <top (required)>'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:636:in
> `call'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:636:in
> `block in execute'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:631:in
> `each'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:631:in
> `execute'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:597:in
> `block in invoke_with_call_chain'
> /Users/rathod/.rvm/rubies/ruby-1.9.2-p180/lib/ruby/1.9.1/monitor.rb:201:in
> `mon_synchronize'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:590:in
> `invoke_with_call_chain'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:583:in
> `invoke'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2051:in
> `invoke_task'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2029:in
> `block (2 levels) in top_level'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2029:in
> `each'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2029:in
> `block in top_level'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2068:in
> `standard_exception_handling'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2023:in
> `top_level'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2001:in
> `block in run'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:2068:in
> `standard_exception_handling'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/lib/rake.rb:1998:in
> `run'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/gems/rake-0.8.7/bin/rake:31:in
> `<top (required)>'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/bin/rake:19:in `load'
> /Users/rathod/.rvm/gems/ruby-1.9.2-p180/bin/rake:19:in `<main>'
>
> --
> Posted via http://www.ruby-forum.com/.
>
>
|
|
|
0
|
|
|
|
Reply
|
Chris
|
3/25/2011 7:09:18 PM
|
|
On Fri, Mar 25, 2011 at 6:18 PM, Rajesh B. <rajesh.13kits@gmail.com> wrote:
> i have installed mysql2 and 64bit mysql server.
> when i run rake db:create it gives me this errror
>
> does any one know whats happening here?
MySQL can't create the database.
A quick google turns up this:
http://groups.google.com/group/sequel-pro/browse_thread/thread/4c1175ac05706d11/8b68c03585c33b1f?pli=1
--
Phillip Gawlowski
Though the folk I have met,
(Ah, how soon!) they forget
When I've moved on to some other place,
There may be one or two,
When I've played and passed through,
Who'll remember my song or my face.
|
|
|
0
|
|
|
|
Reply
|
Phillip
|
3/25/2011 8:39:17 PM
|
|
|
2 Replies
632 Views
(page loaded in 0.122 seconds)
Similiar Articles: Mysql2::Error: Can't create database - comp.lang.rubyOn Fri, Mar 25, 2011 at 6:18 PM, Rajesh B. <rajesh.13kits@gmail.com> wrote: > i have installed mysql2 and 64bit mysql server. > when i run rake db:create it gives me ... Insufficient Access in PCC - comp.databases.btrieveMysql2::Error: Can't create database - comp.lang.ruby Insufficient Access in PCC - comp.databases.btrieve Mysql2::Error: Can't create database - comp.lang.ruby ... PervasiveSQL 9.1 unable to create a database - comp.databases ...Mysql2::Error: Can't create database - comp.lang.ruby... on Create View - comp.databases.btrieve Btrieve index with delphi 5 - comp.databases.btrieve PervasiveSQL 9.1 ... Winspool.drv error on FM Pro 4 running on XP - comp.databases ...Mysql2::Error: Can't create database - comp.lang.ruby Winspool.drv error on FM Pro 4 running on XP - comp.databases ... Mysql2::Error: Can't create database - comp.lang ... ActiveX Component can't create object Windows 7 64 bit - comp ...Mysql2::Error: Can't create database - comp.lang.ruby... comp.lang.java.gui Mysql2::Error: Can't create database - comp.lang.ruby ... solving a "ActiveX component can't ... HTTP error 12002 cannot make a HTTP conection - comp.os.ms-windows ...Mysql2::Error: Can't create database - comp.lang.ruby HTTP error 12002 cannot make a HTTP conection - comp.os.ms-windows ... Mysql2::Error: Can't create database - comp ... couldn't create component peer - comp.lang.java.guiMysql2::Error: Can't create database - comp.lang.ruby couldn't create component peer - comp.lang.java.gui Mysql2::Error: Can't create database - comp.lang.ruby ... solving ... upgrade sms - comp.sys.sun.adminMysql2::Error: Can't create database - comp.lang.ruby On Fri, Mar 25, 2011 at 6:18 PM, Rajesh B. <rajesh.13kits@gmail.com> wrote: > i have installed mysql2 and 64bit mysql ... mysqldump error - comp.databases.mysql... mysqldump db_name -u <user> -p <password> mysqldump: Can't create ... Weird characters (which don't show in the database) - comp ... Weird Error: Unable to Validate Data in ... mysql- creating stored procedures - comp.databases.mysql ...Syntax error trying to return scalar value ... Can't export a pass through query... - comp ... mysql How to check in a stored proc if data is already present? - comp ... create ... Mysql2::Error: Can't create database - comp.lang.ruby | Computer GroupOn Fri, Mar 25, 2011 at 6:18 PM, Rajesh B. <rajesh.13kits@gmail.com> wrote: > i have installed mysql2 and 64bit mysql server. > when i run rake db:create it gives me ... Rake aborted! Mysql2::Error: Can't create/write to file. Rails 3 ...Mysql2::Error: Can't create/write to file. Rails 3 HELP! ... In database.yml file, check the adapter. It should be "mysql2". If not change the adapter to mysql2 ... 7/24/2012 5:12:01 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
4 followers. 