Dnes som si po dlhje dobe konecne naistaloval a podarilo sa mi rozbehnut MySQL. Isiel som si vytvorit databazu a toto mi to vypisalo:
mysql> create database test;
ERROR 1044 (42000): Access denied for user 'tomas'@'%' to database 'test'
neviete mi stim poradit, ako sa da tento problem vyriesit?
MySQL
Pre pridávanie komentárov sa musíte prihlásiť.
root# mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) root# mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 56 Server version: 5.0.51a-24+lenny4 (Debian) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create user krtko; Query OK, 0 rows affected (0.08 sec) mysql> create database krtkova; Query OK, 1 row affected (0.01 sec) mysql> grant all on krtkova.* to krtko@localhost identified by 'tajneheslo'; Query OK, 0 rows affected (0.00 sec) mysql> quit Bye root# su inet inet$ mysql -u krtko -p krtkova Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 59 Server version: 5.0.51a-24+lenny4 (Debian) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create table test (nieco varchar(10)); Query OK, 0 rows affected (0.03 sec) mysql> insert into test values ('jablko'); Query OK, 1 row affected (0.00 sec) mysql> select * from test; +--------+ | nieco | +--------+ | jablko | +--------+ 1 row in set (0.00 sec)[sudo] password for tomas:
root@tomas-nb:~# mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 82
Server version: 5.1.41-3ubuntu12.3 (Ubuntu)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create user tomas;
ERROR 1396 (HY000): Operation CREATE USER failed for 'tomas'@'%'
mysql>