Pridať komentár

Príspevok, na ktorý odpovedáte

Re: MySQL 03.08.2010 | 00:13
Avatar fraxinus Debian 5.0  Používateľ
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)
I am not here. Isn't here just there without a t?
4 * 3 plus tisíc (číslom)

Maximálna veľkosť je: 2,0 MB