views:

37

answers:

2

i've installed mySQL .. i entered my password , but i can't remember they've asked me for a username .. is it admin or root ?

i wanna add the username and password to RubyonRails database.yml

i remember i found a command that tells me the username and password in the mysql console .. but can't find it again !

that's the part i wanna add in my database.yml

development:
 adapter: mysql
 database: myprojectname_development
 username: unknown
 password: devrailspassword
 host: localhost

Since i just started development i don't have a database yet, so there is no way of trial and error ( not that i know of )

A: 

Default username is root.

Riateche
is there any way to make sure ???
msheshtawy
A: 
CREATE USER 'unknown'@'%' IDENTIFIED BY 'devrailspassword';
GRANT ALL PRIVILEGES ON `myprojectname_development`.* TO 'unknown'@'%' WITH GRANT OPTION;
zerkms