jyr / MNPP

Mac + Nginx + Percona + PHP a high performance web server in a one-click installer
http://getmnpp.org
314 stars 49 forks source link

Logged to Percona with root, has no privileges to create tables #68

Closed tbergeron closed 7 years ago

tbergeron commented 11 years ago

I just installed MNPP, so far so good except one thing:

When I try to create a new table I get:

#1006 - Can't create database 'mnpp_test_table' (errno: 2)

Any idea of why this would happen?

Thanks!

tbergeron commented 11 years ago

Wow there's something very wrong: ERROR 1146 (42S02): Table 'mysql.user' doesn't exist

When I try to create a new user, I'll try to re-install MNPP.

tbergeron commented 11 years ago

There's an error because of there's no pidfile when we start mysql/percona. I guess the whole problem is mysql-related in the zip file provided on the website. I'll be trying with the repo version now.

tbergeron commented 11 years ago
$ sudo mnpp percona start
Starting MySQL (Percona Server)
....... ERROR! The server quit without updating PID file (/Applications/MNPP/Library/mysql/var/macbookpro.pid).
tbergeron commented 11 years ago

I created the pid file and started the Percona server:

macbookpro:Library tommybergeron$ sudo mnpp percona start
Starting MySQL (Percona Server)
 SUCCESS! 

Same errors happen. Please take a look at this, I'd love to use MNPP. Thanks!

jyr commented 11 years ago

@tbergeron can you give me more information? like the version MNPP and OS X

tbergeron commented 11 years ago

I'm running OS X 10.8.3, MNPP is now the last version (github version). Thanks