Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- dislexia@dislexia:~$ cat /etc/hosts
- 127.0.0.1 localhost
- 127.0.1.1 dislexia mojserver
- # The following lines are desirable for IPv6 capable hosts
- ::1 ip6-localhost ip6-loopback
- fe00::0 ip6-localnet
- ff00::0 ip6-mcastprefix
- ff02::1 ip6-allnodes
- ff02::2 ip6-allrouters
- dislexia@dislexia:~$ sudo -s
- Password:
- root@dislexia:~# mysql -p
- Enter password:
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
- root@dislexia:~# mysql -p
- Enter password:
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 175
- Server version: 5.5.29-0ubuntu0.12.04.2 (Ubuntu)
- Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
- Oracle is a registered trademark of Oracle Corporation and/or its
- affiliates. Other names may be trademarks of their respective
- owners.
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- mysql> select user () ;
- +----------------+
- | user () |
- +----------------+
- | root@localhost |
- +----------------+
- 1 row in set (0.00 sec)
- mysql> select user, host from mysql, use order by user, host ;
- ERROR 1046 (3D000): No database selected
- mysql> select user, host from mysql, use order by user, host;
- ERROR 1046 (3D000): No database selected
- mysql> select user,host from mysql,use order by user,host;
- ERROR 1046 (3D000): No database selected
- mysql> show database;
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'database' at line 1
- mysql> use wordpress; show tables;
- Reading table information for completion of table and column names
- You can turn off this feature to get a quicker startup with -A
- Database changed
- +-----------------------+
- | Tables_in_wordpress |
- +-----------------------+
- | wp_commentmeta |
- | wp_comments |
- | wp_links |
- | wp_options |
- | wp_postmeta |
- | wp_posts |
- | wp_term_relationships |
- | wp_term_taxonomy |
- | wp_terms |
- | wp_usermeta |
- | wp_users |
- +-----------------------+
- 11 rows in set (0.00 sec)
- mysql> grant all privileges on wordpress.* to wordpress@localhost indetified by "admin";
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'indetified by "admin"' at line 1
- mysql> grant all privileges on wordpress.* to wordpress@localhost indetified by admin;
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'indetified by admin' at line 1
- mysql> grant all privileges on wordpress.* to wordpress@localhost indetified by "admin" ;
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'indetified by "admin"' at line 1
- mysql> Bye
- root@dislexia:~# mysql -u wordpress wordpress -p
- Enter password:
- Reading table information for completion of table and column names
- You can turn off this feature to get a quicker startup with -A
- Welcome to the MySQL monitor. Commands end with ; or \g.
- Your MySQL connection id is 176
- Server version: 5.5.29-0ubuntu0.12.04.2 (Ubuntu)
- Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
- Oracle is a registered trademark of Oracle Corporation and/or its
- affiliates. Other names may be trademarks of their respective
- owners.
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- mysql> ^CCtrl-C -- exit!
- Aborted
- root@dislexia:~# exit
- dislexia@dislexia:~$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement