해결책


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;

신고

import java.sql.DriverManager;

import java.sql.Connection;

import java.sql.SQLException;


public class Example1 {

  public static void main(String[] argv) {

  System.out.println("Checking if Driver is registered with DriverManager.");


  try {

    Class.forName("org.postgresql.Driver");

  } catch (ClassNotFoundException cnfe) {

    System.out.println("Couldn't find the driver!");

    System.out.println("Let's print a stack trace, and exit.");

    cnfe.printStackTrace();

    System.exit(1);

  }


  System.out.println("Registered the driver ok, so let's make a connection.");


  Connection c = null;


  try {

    // The second and third arguments are the username and password,

    // respectively. They should be whatever is necessary to connect

    // to the database.

    c = DriverManager.getConnection("jdbc:postgresql://localhost/DBname",

                                    "DBuser", "DBpassword");

  } catch (SQLException se) {

    System.out.println("Couldn't connect: print out a stack trace and exit.");

    se.printStackTrace();

    System.exit(1);

  }


  if (c != null)

    System.out.println("Hooray! We connected to the database!");

  else

    System.out.println("We should never get here.");

  }

}

신고

postgres@ubuntu:~$ createuser -P -s -e test


새 롤의 암호:

암호 확인:

CREATE ROLE test PASSWORD 'md5f3084041c7669071a1dc54c05d3658cd' SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;

신고

* No PostgreSQL clusters exist; see "man pg_createcluster"


locale 확인

 sudo dpkg-reconfigure locales


After

pg_createcluster 9.X main --start


신고

SHOW FULL COLUMNS FROM table_name;

신고

taiga@ubuntu:~$ psql -U testUser -W testDB -h localhost


psql: FATAL:  Peer authentication failed for user


옵션에 -h localhost를 붙여준다.

신고

#DB 생성

create database testDB with encoding 'unicode' LC_COLLATE 'C' LC_CTYPE 'C' template template0;


#DB Owner 변경

alter database testDB owner to testUser;

신고

taiga=# \du

                             List of roles

 Role name |                   Attributes                   | Member of

-----------+------------------------------------------------+-----------

 postgres  | Superuser, Create role, Create DB, Replication | {}

 taiga     | Superuser, Create role, Create DB              | {}

신고

'Database > PostgreSQL' 카테고리의 다른 글

psql: FATAL: Peer authentication failed for user  (0) 2016.06.27
create database in postgresql  (0) 2016.06.27
postgresql user list  (0) 2016.06.27
PostgreSQL - Ubuntu Basic 설치 가정  (1) 2014.09.02
PostgreSQL Table 전체 조회  (0) 2013.03.25
PostgreSQL  (0) 2013.01.29

+ Recent posts