Category Archives : database

---

Mysql create database then create user. New user can’t login

This entry was posted in database on March 3, 2014 by techstruggles.

When you try to login to mysql with a newly created user, you may get:   ERROR 1044 (42000): Access denied for user Try to ensure the user’s been granted sufficient privileges for the database.   For example, create databases db; create user ‘blah’@’localhost’ with password ‘password’; grant all privileges on db.* to ‘blah’@’%’;  <—–IMPORTANT. […]

---

mysql prompt show utf8

This entry was posted in database on February 9, 2014 by techstruggles.

start mysql prompt with  –default-character-set=utf8 option, like: mysql -u root -p -h  –default-character-set=utf8

---

Mysql: is not allowed to connect to this MySQL serverCsed by foreign host.

This entry was posted in database Sys admin on January 24, 2012 by techstruggles.

If you try to connect from a remote machine to a particular db and get the following: is not allowed to connect to this MySQL serverCsed by foreign host. (connect, as in telnet 3306) Need to set permissions, after logging onto mysql prompt as root: mysql -u root (supply password, if any) GRANT ALL PRIVILEGES […]

---