phpMyAdminにユーザ名でログイン出来ない時

【コマンドライン】

c:\xampp\mysql\bin>mysql -u root -p
Enter password: *****

mysql> SET GLOBAL init_connect='';
Query OK, 0 rows affected (0.00 sec)

mysql>

【phpMyAdmin】
ユーザ名：root
パスワード：●●●●
でログイン

開いたら
SQLをクリックして
クエリ「SET GLOBAL init_connect='';」を書き込み実行クリックすると、ユーザ名でログイン出来るよ。
また、phpのプログラムからmysqlが操作できる様になる。

短縮パスワード

PHPでmysqlへの接続が不可能な場合はパスワードを短くする。ただし、php4の場合だけ、接続に成功した場合はパスワード短縮すると、接続エラーに成る。！

【PHPのプログラム】
//------------------------
//■：サーバーに接続
//------------------------

$my_Con = mysql_connect("localhost","masago","bunbun");

if($my_Con == false){
dir("mysqlの接続に失敗しました。");
}else{
echo "接続成功";
}
?>

【接続失敗したらな】
mysql> select user,password from user where
-> user='masago';
ERROR 1046 (3D000): No database selected
mysql> use mysql
Database changed
mysql> select user,password from user where
-> user='masago';
+--------+-------------------------------------------+
| user | password |
+--------+-------------------------------------------+
| masago | *DAA4BD9F56E4CC1E89AB90F57BAA05C617CBDBA6 |
+--------+-------------------------------------------+
1 row in set (0.14 sec)

mysql> update user set password = old_password('bunbun')
-> where user='masago';
Query OK, 1 row affected (0.11 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.09 sec)

mysql> select user,password from user where
-> user='masago';
+--------+------------------+
| user | password |
+--------+------------------+
| masago | 46c4832022379e1b |
+--------+------------------+
1 row in set (0.00 sec)

ユーザー名でDBにアクセスするには

データーベースにユーザ「masago」を追加し、

c:\xampp\mysql\bin>mysql -u masago -p
Enter password: ******
でログインに成功した。

しかし、
mysql>show databases;
を実施すると、
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 27
Current database: *** NONE ***

ERROR 1184 (08S01): Aborted connection 27 to db: 'unconnected' user: 'test' host:
と言うエラーが出た。

そこで下記のような処理をしたら、無事うまく行った。
c:\xampp\mysql\bin>mysql -u root -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 54
Server version: 5.6.21 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, 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> SHOW GLOBAL VARIABLES LIKE "init%";
+---------------+------------------+
| Variable_name | Value |
+---------------+------------------+
| init_connect | 'SET NAMES utf8' |
| init_file | |
| init_slave | |
+---------------+------------------+
3 rows in set (0.00 sec)

mysql> SET GLOBAL init_connect='';
Query OK, 0 rows affected (0.02 sec)

mysql> \q
Bye

c:\xampp\mysql\bin>mysql -u masago -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 55
Server version: 5.6.21 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, 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> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cooking |
+--------------------+
2 rows in set (0.01 sec)

mysql>

データベースのユーザー権

使用するデーターベースにroot以外のユーザーを追加するには

mysql> grant all privileges on cooking.* to
-> masago@localhost identified by 'bunbun';
Query OK, 0 rows affected (0.17 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.05 sec)

mysql> \q
Bye

c:\xampp\mysql\bin>mysql -u masago -pbunbun
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.6.21

Copyright (c) 2000, 2014, 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>
ユーザーでアクセス成功した。
尚、パスワードを隠したい時には

c:\xampp\mysql\bin>mysql -u masago -p
Enter password: ******

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

javaアプレットのSwingコンポーネント

Swingコンポーネント
現在設定されているLook&Feelとは別のLook&Feelを設定する方法→UIManagerクラスで用意されている「setLookAndFeel」メソッドを使う。

import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.event.*;
import java.util.Vector;

public class UIManagerTest3 extends JFrame implements ActionListener{

public static void main(String[] args){
UIManagerTest3 frame = new UIManagerTest3();

frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.setBounds(10, 10, 450, 300);
frame.setTitle("タイトル");
frame.setVisible(true);
}

UIManagerTest3(){

JButton btn1 = new JButton("Metal");
JButton btn2 = new JButton("CDE/Motif");
JButton btn3 = new JButton("Windows");
JButton btn4 = new JButton("WindowsClassic");

btn1.addActionListener(this);
btn1.setActionCommand("javax.swing.plaf.metal.MetalLookAndFeel");
btn2.addActionListener(this);
btn2.setActionCommand("com.sun.java.swing.plaf.motif.MotifLookAndFeel");
btn3.addActionListener(this);
btn3.setActionCommand("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
btn4.addActionListener(this);
btn4.setActionCommand("com.sun.java.swing.plaf.windows.WindowsClassicLookAndFeel");

JPanel buttonPanel = new JPanel();
buttonPanel.add(btn1);
buttonPanel.add(btn2);
buttonPanel.add(btn3);
buttonPanel.add(btn4);

String[] listData = {"Blue", "Green", "Red", "Whit", "Black", "Yellow"};
JList list = new JList(listData);
JScrollPane scrollPane1 = new JScrollPane();
scrollPane1.getViewport().setView(list);
scrollPane1.setPreferredSize(new Dimension(200, 80));

JPanel listPanel = new JPanel();
listPanel.add(scrollPane1);

JCheckBox checkBox1 = new JCheckBox("JCheckBox1");
JCheckBox checkBox2 = new JCheckBox("JCheckBox2", true);

JPanel checkPanel = new JPanel();
checkPanel.add(checkBox1);
checkPanel.add(checkBox2);

Vector<String> vector = new Vector<String>();
for (int i = 0 ; i < 10 ; i++){
StringBuffer sb = new StringBuffer();
sb.append("JTree Node");
sb.append(i);
vector.add(new String(sb));
}

JTree tree = new JTree(vector);
tree.setRootVisible(true);
JScrollPane scrollPane2 = new JScrollPane();
scrollPane2.getViewport().setView(tree);
scrollPane2.setPreferredSize(new Dimension(200, 80));

JPanel treePanel = new JPanel();
treePanel.add(scrollPane2);

JPanel p = new JPanel();
p.setLayout(new BoxLayout(p, BoxLayout.Y_AXIS));
p.add(listPanel);
p.add(checkPanel);
p.add(treePanel);

getContentPane().add(p, BorderLayout.CENTER);
getContentPane().add(buttonPanel, BorderLayout.PAGE_END);
}

public void actionPerformed(ActionEvent e){
String lafClassName = e.getActionCommand();

try{
UIManager.setLookAndFeel(lafClassName);
SwingUtilities.updateComponentTreeUI(this);
}catch(Exception ex){
System.out.println("Error L&F Setting");
}
}
}