DB_Connect

Ошибка PHP при подключении к базе данных MySQL

В OpenServer создаю БД (user:adm, password:adm, name:my_db). При подключении в PHP выдает ошибки:
1. Warning: mysqli_connect(): (HY000/1049): Unknown database ‘my_db’ in D:\Open Server 5.2.9\OSPanel\domains\Lessons\php\lesson29(DB-connecting_and_selecting_data\home.php on line 11
при правильном имени\пароле:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

       if(mysqli_connect("localhost", "adm", "adm", "my_db")) { echo "Connected"; } else { echo "Not connected"; } ?>  

2. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘adm’@’localhost’ (using password: YES) in D:\Open Server 5.2.9\OSPanel\domains\Lessons\php\lesson29(DB-connecting_and_selecting_data\home.php on line 11
при заведомо переданном неправильном пароле:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

       if(mysqli_connect("localhost", "adm", "wrong", "my_db")) { echo "Connected"; } else { echo "Not connected"; } ?>  

Скрины прилагаю. Я в стадии первых этапов изучения, помогите, пожалуйста, почему не подключается?

Источник

Php warning mysqli connect hy000 1049 unknown database

e.g. Solution 1: I was getting same error when i installed new wampserver 3.2.0, it is an evil it installs MariaDB by default and port 3306 is assigned to it , you cannot even change it. in many cases mysql run in port 3306 but in my mysql it run in port 3308 and I add this: Solution 2: I had a similar problem.

Warning: mysqli_connect(): (HY000/1049): Unknown database in mac terminal only

check your port that mysql run . in many cases mysql run in port 3306 but in my mysql it run in port 3308 and I add this:

$conn = new mysqli("localhost", "root", "", "myDB","3308"); 

I had a similar problem. My code was like this:

$conn=mysqli_connect($servername,$username,$password,$dB) or die("connection failed"); echo "connection success"; 

Problem: I did not indicate the port number. Solution: I just included the port number, like below:

$conn=mysqli_connect($servername,$username,$password,$db,"3308") or die("connection failed"); echo "connection success"; 

Is your PHP environment the same as your browsers PHP? command line php.ini can differ from, for example, your XAMP or other installed webserver

I would recommend checking this first

for me this did the trick

edit your .bash_profile file like

export PATH=/Applications/MAMP/bin/php/php7.1.1/bin:$PATH 

edit the path to your PHP bin from your XAMP

Mysql — Results are different in PHP script and PHPMyAdmin, It’s either a spelling error or PHP code and phpmyadmin are simply using different database credentials. It could happen, for example,

How to Fix «Warning: mysqli_connect(): (HY000/1049)

Y000/1049: Unknown database in PHP MySQL Projects Error

Y000/1049): Unknown database problem solve in php mysqlit is a basic problem of new users Duration: 2:23

Mysqli::real_connect(): (HY000/1049): Unknown database ‘perpus’

[fix codeigniter] Message: mysqli::real_connect(): (HY000/1049): Unknown database ‘perpus Duration: 1:35

Mysqli_connect(): (HY000/1049): Unknown database

Make sure you have created a database and you are in the same one, query like

CREATE DATABASE mydatabasename; USE mydatabasename; 

Refer :- ERROR 1049 (42000): Unknown database ‘mydatabasename’

#1049 Unknown database how to fix the #1049, 1049 Unknown database how to fix the #1049. [fix codeigniter] Message: mysqli Duration: 3:48

Severity: Warning Message: mysqli::real_connect(): (HY000/1049): Unknown database ‘asboha’

Try to separate hostname and port . e.g.

$db['default'] = array( 'dsn' => '', 'hostname' => 'localhost', 'port' => 3306, 

Database Selection Failed Unknown database ‘login’, You need to specify the port. Your database is listening on port 3308. If you are going to use mysqli then please find a better tutorial,

Mysqli::real_connect(): (HY000/1049): Unknown database error in codeigniter

I was getting same error when i installed new wampserver 3.2.0, it is an evil it installs MariaDB by default and port 3306 is assigned to it , you cannot even change it. I think codeigniter/php tries to connect to this port by default. I used following , it worked for me i.e. hostname => ‘localhost:3308’

 $db['default'] = array( 'dsn' => '', 'hostname' => 'localhost:3308', 'username' => 'root', 'password' => '', 'database' => 'soft', 'dbdriver' => 'mysqli', 'dbprefix' => '', 'pconnect' => FALSE, 'db_debug' => (ENVIRONMENT !== 'production'), 'cache_on' => FALSE, 'cachedir' => '', 'char_set' => 'utf8', 'dbcollat' => 'utf8_general_ci', 'swap_pre' => '', 'encrypt' => FALSE, 'compress' => FALSE, 'stricton' => FALSE, 'failover' => array(), 'save_queries' => TRUE ); 

That’s what i did to handle whether db exists or not :

First Change this in application/config/database.php

'db_debug' => (ENVIRONMENT !== 'production') 

Then add these two in your controller

 $this->load->dbforge(); $this->load->dbutil(); 

Then check it in your method

 if( $this->dbutil->database_exists($this->db->database)) < echo 'Database Already Exists'; >else < if($this->dbforge->create_database($this->db->database)) < echo 'Database created successfully !'; >else < print_r($this->db->error()); /* Array ( [code] => 1007 [message] => Can't create database 'my_db'; database exists ) */ > > 

I was too getting this error. There are 2 fields in application/config/database.php file that should match up with your actual database:

'char_set' => 'utf8', 'dbcollat' => 'utf8_general_ci', 

Make sure, the actual DB is of the same type & char_set as mentioned in the above file.

How can i solve this «Warning: mysqli_connect(): (HY000/1049), If you are very sure you have created the database, then go to your connect file and add the port (3308) to your host variable [ private $host =

Источник

ОШИБКА 1049 (42000): неизвестная база данных

Ayman$ mysql -u blog -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1858 

mysql> GRANT ALL PRIVILEGES ON blog_development.* -> TO 'blog'@'localhost' -> IDENTIFIED BY 'newpassword'; Query OK, 0 rows affected (0.01 sec) mysql> SHOW GRANTS FOR 'blog'@'localhost' -> ; +----------------------------------------------------------------------------------------- --------------------+ | Grants for [email protected] | +----------------------------------------------------------------------------------------- --------------------+ | GRANT USAGE ON *.* TO 'blog'@'localhost' IDENTIFIED BY PASSWORD '*FE4F2D624C07AAEBB979DA5C980D0250C37D8F63' | | GRANT ALL PRIVILEGES ON `blog`.* TO 'blog'@'localhost' | | GRANT ALL PRIVILEGES ON `blog_development`.* TO 'blog'@'localhost' | +----------------------------------------------------------------------------------------- --------------------+ 3 rows in set (0.00 sec) 

Кто-нибудь знает, что попробовать? Благодарю! Кроме того, боковое примечание — это странно, у меня есть несколько пользователей root?:

mysql> select User from mysql.user; +------+ | User | +------+ | root | | root | | | | root | | | | blog | | root | +------+ 7 rows in set (0.00 sec) 

Изменить: для тех, кто спрашивает: я создал блог базы данных с командой CREATE DATABASE в MySql. Вот мои активные базы данных:

mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | blog | | mysql | | performance_schema | | test | +--------------------+ 5 rows in set (0.00 sec) 

Источник

“MySQLdump: got error :1049 :unknown database “- How to resolve

Often while performing WHM backups, users notice an error “mysqldump: Got error: 1049: Unknown database”. This can happen when the database does not exist in MySQL.

As a part of our Server Management Services, we help our customers with similar requests related to WHM/ cPanel.

Let us today, discuss the possible reasons and fixes for this error.

What causes “MySQLdump: got error :1049 :unknown database ” error

MySQLdump helps to perform the logical backups, generating a set of SQL statements like DDL, DML for reproduced backup Schema. It dumps one or more MySQL databases for backup or transfers to another SQL server.

We can also generate output in CSV, other delimited text or XML format. The main drawback of MySQLdump is that the restoration procedure can take a long time to execute if the database is very large.

While performing WHM backups, at times, we can see the following error in the backup log:

The backup process encountered the following error: The backup process on “hostname.example.server” encountered an error. [2021-05-10 02:25:26 -0600] mysqldump: Got error: 1049: Unknown database ‘example_database’ when selecting the database

Generally, This error indicates that the related database exists in a cPanel user’s database map, but the database does not exist in MySQL.

How to fix “MySQLdump: got error :1049 :unknown database ” error

The first thing that our Support Engineers perform on seeing this error is to check whether the database exists within MySQL. They does this by running the following command as the root user via SSH:

mysql -e "show databases;" | grep example_database

Replace example_database with the database found within the backup error in the backup logs. We can find the backup logs within /usr/local/cpanel/logs/cpbackup.

If the above command does not display any results, it indicates that the database does not exist in MySQL.

Thus, In order to correct the backup errors, we have to remove the databases that do not actually exist in MySQL from cPanel.

For this, we initially log in to the cPanel account for the particular database user. Then, we navigate to the Databases section and then click on the MySQL Databases option.

Here, we just need to delete the corresponding database from the current database section.

Conclusion

The “MySQLdump: got error :1049 :unknown database ” triggers while performing cPanel backups. This can happen when the database does not exist in MySQL. Today, we saw how our Support Engineers fix this error.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

Источник

How to solve MySQL error 1049 (42000): unknown database ‘database’

In fact, I made a very serious mistake, and this mistake can only be reported for two reasons.
Reason 1: There is an extra space after your account password, which means you have the wrong database.
Fix: If it is a login password, report this error, as shown in the figure below:

It would be possible to have an extra space between p and 123, and then you would remove the space in between. You put p and 123 together and you type in p123
Reason 2: Your syntax is wrong, because use can only be followed by the database name, never the table name. An incorrect or incorrect table name will report the following error.

Solution: Double check your database to see if it has TB_EMP6.

Check your table again to see if it is your table name.

The name of the table is confused with the database name.
Summary is to confirm the database name is not exist, there are no spelling mistakes, if not again to see your grammar is not wrong.
This is better to locate your problem, in fact, to put it bluntly this is I made a stupid mistake, but also eat a catty gain a wisdom.
Hope to help you, welcome to leave a message to exchange ~

Read More:

• MySQL appears: ERROR 1049 (42000): Unknown database’XXX’ solution
• An error is reported when kettle connects Oracle database and MySQL database
• How to view the version of MySQL database
• Solve the database connection failure of Discuz! Database error (1045) notconnect Forum
• Unknown error (SQLite code 14): could not open database (How to Fix)
• Solve MySQL installation error: initializing database prompts an error when installing mysql
• How to Solve mybatis returns null when querying Oracle database with char type field
• Solve the problem of MySQL database report 1055 error
• 1716438 – Error :” Failed to load database information Details: The Database connector crdb_bwquery.
• Hive: How to Solve dearby database initialization error
• PHP connection to MySQL database error: call to undefined function MySQL_ connect()
• An error is reported when logging into mysql. The error message is error 1049 (42000): unknown database ‘XXXXXX’
• The problem of MySQL database connection failure errno: 1049 error
• (error when importing database): MySQL 2006-mysql server has gone away
• java.lang.ClassNotFoundException : com.mysql.jdbc . driver project cannot connect to database, exception, lack of MySQL driver
• ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘mysql’
• An error is reported when the jeecg boot project connects to the MySQL database running on docker
• mysql workbench Error Code: 1046. No database selected Select the default DB to be used
• An error occurs when superstet connects to the Clickhouse database: error: could not load database driver: Clickhouse
• How to Fix Error in module RSQL of the database interface

Источник