oeh jetzt versteh ich nix mehr
ibook:/usr/local/mysql maltespielberger$ cd /usr/local/mysql
ibook:/usr/local/mysql maltespielberger$ sudo ./bin/mysqld_safe&
[1] 1706
? was soll die [1] und dann die zahl??
Wenn ich jedoch den anderen start Befehl verwende:
ibook:/usr/local/mysql maltespielberger$ sudo /usr/local/mysql/bin/mysqld --user=mysql
Password:
050704 14:15:59 Warning: Setting lower_case_table_names=2 because file system for /usr/local/mysql-standard-4.0.25-apple-darwin7.9.0-powerpc/data/ is case insensitive
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
050704 14:16:00 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
050704 14:16:00 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
050704 14:16:01 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
050704 14:16:02 InnoDB: Started
050704 14:16:02 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
050704 14:16:02 Aborting
050704 14:16:02 InnoDB: Starting shutdown...
050704 14:16:04 InnoDB: Shutdown completed
050704 14:16:04 /usr/local/mysql/bin/mysqld: Shutdown Complete
ibook:/usr/local/mysql maltespielberger$ mysql
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Hab mal n bissl gegoogelt und da meinten User, dass wohl an dem mysql User etwas nicht stimmt (die Rechte oder was weiss ich).
Wie setze ich denn die Rechte richtig oder erstelle den Mysql User?
Mit chown -R mysql:mysql bekomm ich nur ne antwort ueber die usage von chown ...
Gruss