MySQL

ii  mysql-server-5.5   5.5.24-0ubuntu0.12.04.1    MySQL database server binaries and system database setup

/etc/mysql/my.cnf を編集する。

[mysqld]

character-set-server = utf8
skip-character-set-client-handshake

/etc/mysql/my.cnf

#bind-address = 127.0.0.1

sudo stop mysql
sudo start mysql

mysql -h localhost -uroot -ptiger

create schema city;
grant all on city.* to scott identified by 'tiger';
flush privileges;

mysql -h localhost -uroot -ptiger

mysql> use mysql;
mysql> select host, User, Password from user;
mysql> drop user 'scott'@'localhost';
mysql> create user 'scott'@'localhost' identified by 'tiger';

mysql> show variables like 'char%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

php5-mysql

python-mysqldb

python3-mysql.connector

libdbd-mysql-ruby

libmysqlclient-dev

sudo gauche-package install Gauche-dbd-mysql-0.2.2.tgz

mysqltcl

com.mysql.jdbc.CommunicationsException: Communications link failure

/etc/tomcat6/policy.d

	policytool

libmysql-java

mysqld を止める。

--skip-grant-tables オプションを指定して mysqld を再起動。

mysqladmin password コマンドで新しいパスワードを設定。

shell> mysqladmin -u root password 'mynewpassword'

mysqld を再起動。

ユーザーの確認

> select Host, User, Password from mysql.user;

データーベースの確認

> show databases;

May/09/2023 AM 08:15