MariaDB - Versionshistorik

Js146669: /* Import */

2017-09-18T19:14:04Z

‎Import

Js146669: /* Database status */

2017-09-18T19:13:31Z

‎Database status

Js146669 den 7 september 2017 kl. 18.54

2017-09-07T18:54:41Z

Js146669 den 6 september 2017 kl. 05.54

2017-09-06T05:54:34Z

Js146669 den 5 september 2017 kl. 20.45

2017-09-05T20:45:44Z

Js146669 den 5 september 2017 kl. 20.34

2017-09-05T20:34:47Z

Js146669 den 5 september 2017 kl. 20.24

2017-09-05T20:24:43Z

Js146669: MariaDB info

2017-09-05T20:09:57Z

MariaDB info

Ny sida

MariaDB TX keeps your data safe and your applications running.

[[Fil:Exempel.jpg]]

@@ Rad 75: / Rad 75: @@
 Import a database dump:
    # mysql -u [username] -p -h localhost [database] < db_backup.sql
-   Logout
+   ''Logout''
    > exit;

@@ Rad 51: / Rad 51: @@
    # mysql -u root -p
    > show databases;
-   Select database:
+   ''Select database''
    > use [database];
    > create database [database];
-   > status
+   ''Status info''
    > show processlist;
    > SHOW GLOBAL STATUS;
@@ Rad 62: / Rad 62: @@
    > show variables like 'version%';
    > show variables like '%userstat%';
 == Users functions ==

← Äldre version		Versionen från 7 september 2017 kl. 18.54
Rad 47:		Rad 47:
	<li> '''Auditing:''' Local autdit logs, Remote centralised audit logs. To counter lack of visibility in security breaches Unmet compliance regualation and GDPR regulations (Req'd by EU to be implemented by May 2018)</li>		<li> '''Auditing:''' Local autdit logs, Remote centralised audit logs. To counter lack of visibility in security breaches Unmet compliance regualation and GDPR regulations (Req'd by EU to be implemented by May 2018)</li>
	</ul>		</ul>
		+
		+	== Database status ==
		+	# mysql -u root -p
		+	> show databases;
		+	Select database:
		+	> use [database];
		+	> create database [database];
		+	> status
		+	> show processlist;
		+	> SHOW GLOBAL STATUS;
		+	> SHOW STATUS LIKE 'Key%';
		+	> SHOW STATUS LIKE '%Tables%';
		+	''Show Variables''
		+	> show variables like 'version%';
		+	> show variables like '%userstat%';
		+
		+
		+	== Users functions ==
		+	List all users: > SELECT User,Host FROM mysql.user;
		+	Create new user: > CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
		+	Grant ALL access to user for * tables: > GRANT ALL ON database.* TO 'user'@'localhost';
		+	show user privs > show grants;
		+	Grant all right > grant all privileges on . to 'soltec'@'%' with grant option;
		+	display for user > show grants for soltec;
		+	Set password > set password for 'soltec'@'%' = password(‘cleartext’);
		+
		+	== Import ==
		+	Import a database dump:
		+	# mysql -u [username] -p -h localhost [database] < db_backup.sql
		+	Logout
		+	> exit;

@@ Rad 10: / Rad 10: @@
    ''MariaDB services'' – access is available via an enterprise open source subscription.
-== start/stop cli ==
+== CLI start/stop ==
 == Security ==

@@ Rad 2: / Rad 2: @@
 == MariaDB ==
+'''MariaDB TX''', when deployed, is comprised of
 == start/stop cli ==

@@ Rad 1: / Rad 1: @@
 MariaDB TX keeps your data safe and your applications running.
 <UL>
-<li>Encryption: TLS for encrypted connections and AES for encrypted Storage. To counter "Man-in-the-Middle", Package sniffing, Compromised Architecture and Internal bad actors. N.B! SPARC sun4v CPU has this encryption already built into the chip hardware so increasing database performance</li>
+  <li>  '''Encryption:''' TLS for encrypted connections and AES for encrypted Storage. To counter "Man-in-the-Middle", Package sniffing, Compromised Architecture and Internal bad actors. N.B! SPARC sun4v CPU has this encryption already built into the chip hardware so increasing database performance</li>
-<li>Database Proxy: Query whitelisting/blacklisting and Data masking. To counter DoS, SQL Injection, Application spoofing. N.B! All of these are protected by software in silicon på SPARC M7 CPUs. </li>
+  <li>  '''Database Proxy:''' Query whitelisting/blacklisting and Data masking. To counter DoS, SQL Injection, Application spoofing. N.B! All of these are protected by software in silicon på SPARC M7 CPUs. </li>
-<li>User Management: LDAP user & group mapping, RBAC, PAM authentication, Password validation. To counter compromised application servers, Human error and Bad actors. Compatible with standard Linux tools for connecting with AD authentication using SSD, PAM, Samba and Kerberos.</li>
+  <li>  '''User Management:''' LDAP user & group mapping, RBAC, PAM authentication, Password validation. To counter compromised application servers, Human error and Bad actors. Compatible with standard Linux tools for connecting with AD authentication using SSSD, PAM, Samba and Kerberos.</li>
-<li>Auditing: Local autdit logs, Remote centralised audit logs. To counter lack of visibility in security breaches Unmet compliance regualation and GDPR regulations (Req'd by EU to be implemented by May 2018)</li>
+  <li>  '''Auditing:''' Local autdit logs, Remote centralised audit logs. To counter lack of visibility in security breaches Unmet compliance regualation and GDPR regulations (Req'd by EU to be implemented by May 2018)</li>
 </ul>

← Äldre version		Versionen från 5 september 2017 kl. 20.24
Rad 1:		Rad 1:
	MariaDB TX keeps your data safe and your applications running.		MariaDB TX keeps your data safe and your applications running.

−	~~[[Fil~~:~~Exempel~~.~~jpg]]~~	+	<UL>
		+	<li>Encryption: TLS for encrypted connections and AES for encrypted Storage. To counter "Man-in-the-Middle", Package sniffing, Compromised Architecture and Internal bad actors. N.B! SPARC sun4v CPU has this encryption already built into the chip hardware so increasing database performance</li>
		+
		+	<li>Database Proxy: Query whitelisting/blacklisting and Data masking. To counter DoS, SQL Injection, Application spoofing. N.B! All of these are protected by software in silicon på SPARC M7 CPUs. </li>
		+
		+	<li>User Management: LDAP user & group mapping, RBAC, PAM authentication, Password validation. To counter compromised application servers, Human error and Bad actors. Compatible with standard Linux tools for connecting with AD authentication using SSD, PAM, Samba and Kerberos.</li>
		+
		+	<li>Auditing: Local autdit logs, Remote centralised audit logs. To counter lack of visibility in security breaches Unmet compliance regualation and GDPR regulations (Req'd by EU to be implemented by May 2018)</li>
		+	</ul>