I work with the mysql console. The need arose because you need to import a large database (more than 115 MB). In phpMyAdmin, it crashes, even when I change the lifetime of waiting for file uploads in php.ini, as well as their maximum size. I do console work with mysql through standard cmd process. For this, I wrote the mysql directory in variable environments. Naturally I launch Denver, then from the console I enter mysql. Through the phpMyAdmin shell, it shows 10 databases, and only two through the console. My database does not see, in which I need to fill in mega-data).

I do command show databases;

What is the reason? Explain to me, please.

  • It seems that under the user under which you connect to the console there is no access to the other databases. mysql -uroot root, watched mysql -uroot ? - jekaby
  • I'm sitting under the rue. He sees everything, because he had to see all the bases. The command -uroot also used naturally. The command dumps a 1064 error and writes: You have an error in your SQL syntax check the manual ... etc. - IntegralAL
  • Either under different users connect, or on different mysql hosts. On denver your mysql? Can a non-standard port be used? I just did not work with denwer. Let denwer specialists tell you) - jekaby
  • There is one user in the system - root. There is a standard assembly Denver. mysql is also one of those standard Denver builds. Port 8648, which defaults to Denver, is free. Ports have nothing to do with it, since it outputs the bases, but somehow it’s fragmentary. Because really I am waiting for specialists from Denverchan), they must clarify the situation. - IntegralAL
  • If it is not difficult to execute in the mysql console a query SELECT CURRENT_USER (); what does he derive? - cheops

1 answer 1

Log into MySQL from the console using the command: mysql -uroot. Next show databases.

  • Abstract concept "go into mysql"). I wrote that through the windows environment variables I registered the launch of mysql there through the usual cmd. So when I run cmd, then I write mysql, and then I write -uroot, I get the error: Error 1064 Syntax: I’m syntax: uroot 'at line 1. That's what the console is writing to me ... - IntegralAL
  • @IntegralAL this "-p8648 -uroot" should be specified when connecting to mysql, and not after. - jekaby
  • In any case, the problem is the same. Two bases are visible, and from the phpmyadmin shell 10 bases. Question 10 - 2 = 8. Where are the other eight bases? - IntegralAL