해결책


GRANT ALL PRIVILEGES ON *.* TO <username>@'%' IDENTIFIED BY <password>;


import java.sql.DriverManager;

import java.sql.Connection;

import java.sql.SQLException;


public class JDBCExample {


  public static void main(String[] argv) {


        System.out.println("-------- MySQL JDBC Connection Testing ------------");


        try {

                Class.forName("com.mysql.jdbc.Driver");

        } catch (ClassNotFoundException e) {

                System.out.println("Where is your MySQL JDBC Driver?");

                e.printStackTrace();

                return;

        }


        System.out.println("MySQL JDBC Driver Registered!");

        Connection connection = null;


        try {

                connection = DriverManager

                .getConnection("jdbc:mysql://localhost:3306/testDB","root", "password");


        } catch (SQLException e) {

                System.out.println("Connection Failed! Check output console");

                e.printStackTrace();

                return;

        }


        if (connection != null) {

                System.out.println("You made it, take control your database now!");

        } else {

                System.out.println("Failed to make connection!");

        }

  }

}

sudo systemctl stop mysqld


mysqld_safe --skip-grant-tables &


mysql

mysql> use mysql

mysql> update user set password=PASSWORD('passwd') where User='root';

mysql> flush privileges;

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum update
sudo yum install mysql-server
sudo systemctl start mysqld


SHOW FULL COLUMNS FROM table_name;

+ Recent posts