Ubuntu/mysql - Revision history

R00t at 02:10, 10 August 2022

2022-08-10T02:10:06Z

R00t at 01:44, 10 August 2022

2022-08-10T01:44:46Z

R00t at 05:17, 13 March 2021

2021-03-13T05:17:49Z

R00t at 05:15, 13 March 2021

2021-03-13T05:15:52Z

R00t at 15:39, 1 April 2020

2020-04-01T15:39:29Z

R00t at 06:59, 6 May 2016

2016-05-06T06:59:50Z

R00t: /* =Create Database */

2016-05-06T06:56:55Z

‎=Create Database

R00t at 06:56, 6 May 2016

2016-05-06T06:56:45Z

R00t at 06:53, 6 May 2016

2016-05-06T06:53:21Z

R00t at 19:24, 5 August 2015

2015-08-05T19:24:00Z

@@ Line 153: / Line 153: @@
 creating a new user called user with a password of password
   <nowiki>mysql> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';</nowiki>
 ==Grant access to database==

← Older revision		Revision as of 01:44, 10 August 2022
Line 158:		Line 158:
	<nowiki>mysql> grant all privileges on artifactorydb.* to 'artifactory'@'%';		<nowiki>mysql> grant all privileges on artifactorydb.* to 'artifactory'@'%';
	Query OK, 0 rows affected (0.00 sec)</nowiki>		Query OK, 0 rows affected (0.00 sec)</nowiki>
		+
		+	==Show Grants==
		+	show grants for a user
		+	<nowiki>MariaDB [(none)]> SHOW GRANTS FOR 'grafana'@'%';</nowiki>

@@ Line 141: / Line 141: @@
 Create a super basic table with a couple of columns.
   <nowiki>mysql> CREATE TABLE test (id INT NOT NULL, name VARCHAR(100) NOT NULL);</nowiki>
 ==Create Database==

@@ Line 137: / Line 137: @@
   <nowiki>~$mysql> update user set password=PASSWORD('your_new_password') where User='changed_user';</nowiki>
 ----<br>
 ==Create Database==

← Older revision		Revision as of 15:39, 1 April 2020
Line 145:		Line 145:
	creating a new user called user with a password of password		creating a new user called user with a password of password
	<nowiki>mysql> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';</nowiki>		<nowiki>mysql> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';</nowiki>
		+
		+	==Grant access to database==
		+	granting access to database for user
		+	<nowiki>mysql> grant all privileges on artifactorydb.* to 'artifactory'@'%';
		+	Query OK, 0 rows affected (0.00 sec)</nowiki>

← Older revision		Revision as of 06:59, 6 May 2016
Line 141:		Line 141:
	creating a db called temp.		creating a db called temp.
	<nowiki>mysql> CREATE DATABASE temp;</nowiki>		<nowiki>mysql> CREATE DATABASE temp;</nowiki>
		+
		+	==Create a new user==
		+	creating a new user called user with a password of password
		+	<nowiki>mysql> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';</nowiki>

@@ Line 138: / Line 138: @@
 ----<br>
-==Create Database=
+==Create Database==
 creating a db called temp.
   <nowiki>mysql> CREATE DATABASE temp;</nowiki>

← Older revision		Revision as of 06:56, 6 May 2016
Line 137:		Line 137:
	<nowiki>~$mysql> update user set password=PASSWORD('your_new_password') where User='changed_user';</nowiki>		<nowiki>~$mysql> update user set password=PASSWORD('your_new_password') where User='changed_user';</nowiki>
	----<br>		----<br>
		+
		+	==Create Database=
		+	creating a db called temp.
		+	<nowiki>mysql> CREATE DATABASE temp;</nowiki>

@@ Line 1: / Line 1: @@
 ;mysql is one of the most popular database applications on the market today
 <br\>
-mysql login
+==mysql login==
   mysql -u <user> -p
 will then prompt you for a password
 <br\>
-mysqladmin login
+==mysqladmin login==
   mysqladmin -u <user> -p
 you can also run other commands after -p, such as:<br\>
 see if the database is running
   status
-change MySQL root pass
+==change MySQL root pass==
   sudo dpkg-reconfigure mysql-server-5.1
-verify MySQL is running
+==verify MySQL is running==
   sudo netstat -tap | grep mysql
-determine MySQL version
+==determine MySQL version==
   <nowiki>~$ mysql --version
 mysql  Ver 14.14 Distrib 5.1.73, for debian-linux-gnu (i486) using readline 6.1
@@ Line 39: / Line 39: @@
 +-------------------------+-------------------------+
 rows in set (0.00 sec)</nowiki>
-backup wiki mysql database
+==backup wiki mysql database==
   sudo -s
   mysqldump -u user -p db.name > wikidatabasebackup.sql
   i.e. mysql -u wikiuser -p wikidb > /var/www/mediawiki/backup/wikidatabasebackup10_4_12.sql
-view all databases
+==view all databases==
   ~$ mysql -u root -p
   ~mysql>SHOW DATABASES;
@@ Line 54: / Line 54: @@
   +--------------------+
 rows in set (0.00 sec)
-determine which database is selected
+==determine which database is selected==
   <nowiki>mysql> SELECT DATABASE();
 +------------+
@@ Line 73: / Line 73: @@
 row in set (0.00 sec)</nowiki>
-select a database
+==select a database==
   mysql> USE wikidb;
-show tables in a database
+==show tables in a database==
   <nowiki>mysql> SHOW TABLES;
 +--------------------+
@@ Line 88: / Line 88: @@
 rows in set (0.00 sec)</nowiki>
-show structure of table
+==show structure of table==
   <nowiki>mysql> DESCRIBE category;
 +-------------+---------------------+------+-----+---------+----------------+
@@ Line 102: / Line 102: @@
 rows in set (0.00 sec)</nowiki>
-select all data from a table
+==select all data from a table==
   <nowiki>mysql> SELECT * FROM user;
 +---------+------------+-----------------+----------------------------------------------+----------------------------------------------+-------------------+-------------------------------+----------------+----------------------------------+--------------------------+----------------------------------+--------------------------+-------------------+----------------+
@@ Line 110: / Line 110: @@
 row in set (0.00 sec)</nowiki>
-delete (drop) a database
+==delete (drop) a database==
   ~mysql> DROP DATABASE IF EXISTS <db name>;
   Query OK, 11 rows affected (0.04 sec)
-list all users
+==list all users==
   ~mysql> SELECT User,Host FROM mysql.user;
   +------------------+-----------------+
@@ Line 125: / Line 125: @@
   +------------------+-----------------+
 rows in set (0.00 sec)
-delete a user
+==delete a user==
   ~mysql> DROP USER 'wordpress'@'localhost';
   Query OK, 0 rows affected (0.00 sec)
 ----<br>
-Change a mysql user's password.<br>
+==Change a mysql user's password.==
 Login as root.
   <nowiki>~$ mysql -u root -p</nowiki>