getting started with MariaDB

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

getting started with MariaDB

Postby richb201 » 18. December 2016 18:45

I have loaded up the XAMPP control panel and am able to start and stop MariaDB. I am following examples in PHP & MySQL, The Missing Manual. The instruction say to use "show databases", but when I do this it only shows test and information_schema. I was told that I need to type "use mysql;". The only problem is that the mysql database is not in my current directory and or is not pathed correctly. I get error 1044 access denied for user ' '@' localhost' to database 'mysql'. It must be something with my config. Can any point me to setup instructs that will get me to the correct directory to allow show databases to show "mysql" as an available database?
richb201
 
Posts: 8
Joined: 18. December 2016 18:15
XAMPP version: 3.2.2
Operating System: win 7

Re: getting started with MariaDB

Postby Altrea » 18. December 2016 19:28

Ask the author why you are logged in with an anonymous user instead of a priviledged user.
We cannot debug any foreign tutorials. You must have done something to force this behavior. That is not by default.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: getting started with MariaDB

Postby Nobbie » 18. December 2016 20:16

richb201 wrote:Can any point me to setup instructs that will get me to the correct directory to allow show databases to show "mysql" as an available database?


Yes. SImply undo ALL changes you did (or de-install Xampp and install it again), as you obiously destroyed an "out of the box" working environment by doing such (which??) changes. Later on, simply start phpmyadmin from the Xampp dashboard. The idea of Xampp is to provide a full working environment without the need of doing any changes, but unfortunately you immediately seems to override and destroy these settings. For what reason ever.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: getting started with MariaDB

Postby richb201 » 18. December 2016 21:31

OK. I uninstalled, made sure that Kaspersky was turned off, and then reinstalled. Then I use XAMPP to start the MySQL server. I then used the "shell" in the XAMPP control panel v3.2.2 and typed mysql (why did I need to do this since I already started MariaDB monitor, but, what the heck) at the # prompt which was at C:\xampp. Then at the MariaDB[none]> prompt I typed show databases hoping that it would now show the built in mysql database. Again, I am in the wrong directory. What is wrong here?
richb201
 
Posts: 8
Joined: 18. December 2016 18:15
XAMPP version: 3.2.2
Operating System: win 7

Re: getting started with MariaDB

Postby Nobbie » 18. December 2016 22:39

richb201 wrote:why did I need to do this since I already started MariaDB monitor, but, what the heck


Very good question - who told you to do so? I didnt!

richb201 wrote:What is wrong here?


So what is wrong? You simply do not have the slightest clue, what you are doing there. That is "wrong".

Why dont you simply use Phpmyadmin in order to manage your databases? Of course, if you prefer, you might use the command line interpreter "mysql" instead (thats what you are going to do currently), but this requires quite a lot of knowlegde about SQL and Databases. You asked "why did i need to do this" and honestly, i dont know why you do so. It is not suggested by any official Xampp documentation neither by me.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: getting started with MariaDB

Postby richb201 » 19. December 2016 08:29

OK. So I followed your instructs and decided to use PhpMyAdmin. I downloaded it and also bought phpMyAdmin Starter ebook. On page 4 it says to download phpMyAdmin-4.6.5.2-all-languages which I did and then "unpack" the archive. Anyway, it created an entire structure with subdir's: doc, examples, js, libraries, locale, setup, etc. The instructs from the phpMyAdmin Starter says that a dir called phpMyAdmin-3.4.3.1 should have been created, but it didn't work like this. Next Step 3 Configuring phpMyAdmin says I should have a file called config.inc.php in the top level dir. The closest thing I have is config.sample.inc.php. Can I assume that these are the same? Anyway, when I click on that file I get Windows saying that it doesn't know what program to use to open a php file.I have started Apache and MySQL via the XAMPP control panel. So how to I get the config.sample.inc.php to be associated with localhost?
richb201
 
Posts: 8
Joined: 18. December 2016 18:15
XAMPP version: 3.2.2
Operating System: win 7

Re: getting started with MariaDB

Postby Nobbie » 19. December 2016 11:28

WHY???

Xampp already includes a preconfgured Phpmyadmin, simply open http://localhost and click on the link Phpmyadmin or directly enter http://localhost/phpmyadmin
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: getting started with MariaDB

Postby richb201 » 19. December 2016 14:01

Got it. Thx
richb201
 
Posts: 8
Joined: 18. December 2016 18:15
XAMPP version: 3.2.2
Operating System: win 7


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 12 guests