You need to grant privileges:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH
GRANT OPTION;
Arie Fishler wrote:
check that there is actually a name in the DNS for int-mysql-master.mydomain.com
for example ping it.
Also try using the IP address to connect and not the name.
On Tue, Feb 17, 2009 at 7:33 PM, kenja <[email protected]>
wrote:
I'm using the 32 bit mysql image and am trying to set up my
application. I've set the root password via:
mysqladmin -u root password mypsswd
I loaded the databases from my old server:
mysql -u root -p <databases.sql
And configured the application on the app server to use the new
credentials:
username "root"
password "mypsswd"
host "int-mysql-master.mydomain.com"
database "mydatabase"
I verified port 3306 is open to the world and I'm still getting mysql
connection errors:
Database Error: Unable to connect to the database:Could not connect to
MySQL
Am I missing something basic? Is there another user account that
needs to be created? Mysqld is running and I've logged into mysql on
the server to verify my databases were imported correctly. There
don't appear to be any error messages in the system log.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "scalr-discuss" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/scalr-discuss?hl=en
-~----------~----~----~----~------~----~------~--~---
|
