Mysql - Revision history

Scott: /* Searching on three-character words */

2024-11-05T22:12:51Z

Searching on three-character words

← Older revision		Revision as of 22:12, 5 November 2024
Line 79:		Line 79:

	== Searching on three-character words ==		== Searching on three-character words ==
	* Edit <code>/etc/mysql/mysql.cnf</code> to add this line to the <code>[mysqld]</code> section (create section if it doesn't exist):		* Edit <code>/etc/mysql/mysql.cnf</code> or <code>/etc/mysql/mysql.conf.d/mysqld.cnf</code> to add this line to the <code>[mysqld]</code> section (create section if it doesn't exist):
	<pre>		<pre>
	[mysqld]		[mysqld]

2024-10-25T20:25:38Z

← Older revision		Revision as of 20:25, 25 October 2024
Line 9:		Line 9:
	ERROR in UBUNTU 22.04 solved here:		ERROR in UBUNTU 22.04 solved here:
	https://www.nixcraft.com/t/mysql-failed-error-set-password-has-no-significance-for-user-root-localhost-as-the-authentication-method-used-doesnt-store-authentication-data-in-the-mysql-server-please-consider-using-alter-user/4233		https://www.nixcraft.com/t/mysql-failed-error-set-password-has-no-significance-for-user-root-localhost-as-the-authentication-method-used-doesnt-store-authentication-data-in-the-mysql-server-please-consider-using-alter-user/4233
			<pre>
			ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'SetRootPasswordHere';
			</pre>

	Log in as root to mysql database		Log in as root to mysql database

2024-03-28T19:15:13Z

Searching on three-character words

← Older revision		Revision as of 19:15, 28 March 2024
Line 86:		Line 86:
	repair table <table_name> quick;		repair table <table_name> quick;
	</pre>		</pre>
			* Restart mysql and any dependent apps.

	== Create database/table example ==		== Create database/table example ==

2024-03-28T19:14:29Z

Searching on three-character words

← Older revision		Revision as of 19:14, 28 March 2024
Line 76:		Line 76:

	== Searching on three-character words ==		== Searching on three-character words ==
	* Edit <code>/etc/mysql~~/conf.d~~/mysql.cnf</code> to add this line to the <code>[mysqld]</code> section:		* Edit <code>/etc/mysql/mysql.cnf</code> to add this line to the <code>[mysqld]</code> section (create section if it doesn't exist):
	<pre>		<pre>
			[mysqld]
	ft_min_word_len=3		ft_min_word_len=3
	</pre>		</pre>

2024-03-28T19:08:24Z

Searching on three-character words

← Older revision		Revision as of 19:08, 28 March 2024
Line 76:		Line 76:

	== Searching on three-character words ==		== Searching on three-character words ==
	* Edit <code>/etc/mysql/my.cnf</code> to add this line to the <code>[mysqld]</code> section:		* Edit <code>/etc/mysql/conf.d/mysql.cnf</code> to add this line to the <code>[mysqld]</code> section:
	<pre>		<pre>
	ft_min_word_len=3		ft_min_word_len=3

2023-07-10T23:29:39Z

Ubuntu setup

← Older revision		Revision as of 23:29, 10 July 2023
Line 6:		Line 6:
	mysql_secure_installation		mysql_secure_installation
	</pre>		</pre>

			ERROR in UBUNTU 22.04 solved here:
			https://www.nixcraft.com/t/mysql-failed-error-set-password-has-no-significance-for-user-root-localhost-as-the-authentication-method-used-doesnt-store-authentication-data-in-the-mysql-server-please-consider-using-alter-user/4233

	Log in as root to mysql database		Log in as root to mysql database
	<pre>		<pre>

2023-04-25T21:46:31Z

Ubuntu setup

← Older revision		Revision as of 21:46, 25 April 2023
Line 18:		Line 18:
	grant file on . to barney@localhost; # write output to files		grant file on . to barney@localhost; # write output to files
	flush privileges;		flush privileges;
			</pre>

			== Show Permissions ==
			Logged in as root:
			<pre>
			show grants for barney@localhost;
	</pre>		</pre>

2021-01-01T18:16:03Z

Ubuntu setup

← Older revision		Revision as of 18:16, 1 January 2021
Line 2:		Line 2:
	Have a <code>mysql</code> root password ready to go.		Have a <code>mysql</code> root password ready to go.
	<pre>		<pre>
	apt~~-get~~ install mysql-server mysql-client libmysqlclient-dev		apt install mysql-server mysql-client libmysqlclient-dev
	apt~~-get~~ install python3-mysqldb # if using python to access mysql		apt install python3-mysqldb # if using python to access mysql
	mysql_secure_installation		mysql_secure_installation
	</pre>		</pre>

2020-07-30T19:06:32Z

Backing up and restoring a database

← Older revision		Revision as of 19:06, 30 July 2020
Line 58:		Line 58:
	<pre>		<pre>
	export MYSQL_PWD=XXXXX		export MYSQL_PWD=XXXXX
	mysqldump --opt bookstore > bookstore.sql		mysqldump --no-tablespaces --opt bookstore > bookstore.sql
	</pre>		</pre>
	To restore a database from backup (overwrites any existing):		To restore a database from backup (overwrites any existing):

2020-05-11T23:02:35Z

Ubuntu setup

← Older revision		Revision as of 23:02, 11 May 2020
Line 3:		Line 3:
	<pre>		<pre>
	apt-get install mysql-server mysql-client libmysqlclient-dev		apt-get install mysql-server mysql-client libmysqlclient-dev
	apt-get install ~~python~~-mysqldb # if using python to access mysql		apt-get install python3-mysqldb # if using python to access mysql
	mysql_secure_installation		mysql_secure_installation
	</pre>		</pre>